There are no "setting/cpu/mem tweaks". What we do have is:
1) Database design. A good design does not guarantee good performance, but a bad design can absolutely guarantee bad performance.
2) Indexes. Proper indexing is the key to getting good performance from a well designed database. Sometimes it can even get good performance from a badly designed database.
3) Queries. A badly written query can ruin performance, while a properly written query can make use of the right indexes and at least have the possibility of working well.
Sometimes the shortest path to achieving the above is it enlist professional help.
No comments:
Post a Comment