Ways To speed up the database applications

[Murali]

Hi all,

I want to know the different tips of improving the performance/speed of database applications.

thanx

[JHausmann]

Thats kind of like asking us what kind of car you should buy.

1) you need to determine where your bottlenecks are

2) you need to determine if your locking scheme is correct

3) you need to determine if your indexing scheme is correct

4) you need to determine if you need RI

5) you need to establish maintenance process for the database (compacting data, updating statistics, etc.)