l*u
发帖数: 9 | 1 Can anybody has answer for this question? Thank you!
How to improve performance of Database? |
c**t
发帖数: 2744 | 2 Index, optimized queries...
【在 l*u 的大作中提到】
: Can anybody has answer for this question? Thank you!
: How to improve performance of Database?
|
l*m
发帖数: 4 | 3 Optimize your DB design.
Ask yourself, what is the most typical transactions?
How can I optimize it ?
Use more store procedures.
Another way is to do experiments to teat and compare.
【在 c**t 的大作中提到】
: Index, optimized queries...
|
m**********m
发帖数: 92 | 4 use tools like statspack to collect performance statistics regularly.
【在 l*m 的大作中提到】
: Optimize your DB design.
: Ask yourself, what is the most typical transactions?
: How can I optimize it ?
: Use more store procedures.
: Another way is to do experiments to teat and compare.
|
