How to improve performance of Database?# Database - 数据库
l*u
1 楼
Can anybody has answer for this question? Thank you!
How to improve performance of Database?
How to improve performance of Database?
c*t
2 楼
Index, optimized queries...
【在 l*u 的大作中提到】
: Can anybody has answer for this question? Thank you!
: How to improve performance of Database?
【在 l*u 的大作中提到】
: Can anybody has answer for this question? Thank you!
: How to improve performance of Database?
l*m
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...
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
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.
【在 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.
相关阅读
请问：主修MIS(Management Information System) 在北美好找工作吗？Re: 在SQL SERVER 或其他DBMS中, 有没有类似于ACCESS中的RELATIONSHIP的东西?い瓣ㄈ瑆程淮计沮畐盡產[转载] Why Data Center Server domed?where is ora 00922 from?Babylon, will iAS replace OAS?[转载] SQL Server 2000how to see all the tables in SQL*PLUS? Error Code 01034?simple access question想找个拍卖网站的数据库范例,where can i find it?what's difference between MIS and CS?如何将ORACLE在UNIX下的数据转道NT下的ORACLE？What does a data administrator do?about:SQL的执行效率any db2 expert?db2 charactor 的数据类型Question about MySQLquestion about oracle 8i personal editionMySql goes GPL