| Author |
 Topic  |
|
|
Webbo
Average Member
United Kingdom
982 Posts |
 Posted - 15 October 2008 : 23:48:05
|
In my MySql database runtime information I have the following value for the Select_full_join variable: 3,840 k
The description for that variable is:
"The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables."
Is there a guide that I can use to check the indexes for the Snitz tables, otherwise I'm working blind?
< |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 October 2008 : 05:42:45
|
| What guide should there be? Indexing is meant to optimize performance. For that, a detailed knowledge of the "questions" submitted to the database is needed. With the many queries Snitz uses, and that were developed by many different people over many years, you don't have that many options other than putting out fires - if there is a problem, look at it, find the intervening queries, have a look at existing indexes and fix it. If you don't have performance problems, don't waste your time.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 16 October 2008 : 16:58:26
|
quote:
If you don't have performance problems, don't waste your time.
Sounds good to me  < |
|
|
| |
Topic |
|
|
|
Topic Locked
