| Author |
 Topic  |
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 01 May 2008 : 16:51:23
|
Hard to say, really. One thing that you could do if you have the possibility would be to set a profiler session running for some time to get a good sample of the load imposed on the database and then use that info to get advice from Index Tuning Wizard on how to optimize the indexing, that leaves much to be desired (a simple example - there is no index on username and password on the members table). Adding that in a low traffic forum improved response times in certain situations where getting the first page to show up could take a lot of time.
Then you can get your most visited pages and see what you can do to improve performance. Regardless of the improvements that could result from changes to the indexes, there are queries that can benefit from huge improvements. For example, there are several queries that use OUTER JOINs and that can be rewritten not to use them. SQL Server handles outer joins much better than MySQL, but it can still benefit if they are not used at all.
Archiving will always help, even if the archived tables could do with some indexing as well.
Periodically rebuilding database indexes is a must as well, whether with a revamping indexing scheme, or the default one.
All in all, quite some work, but can benefit performance in the end.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
|
|
Topic Locked
