Hi all,
I want to know the different tips of improving the performance/speed of database applications.
thanx
Printable View
Hi all,
I want to know the different tips of improving the performance/speed of database applications.
thanx
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.)