Page: 1 | Rating: Unrated [0] |
Top 10 Posters
|
Coolness: 2604105
| Top 10 Weekly is updated every 6 hours...
Top 10 Monthly is updated every 24 hours...
---> They will be updated when people run the script so please note that the top 10 can take up to 30 seconds to display IF the script has to run... It won't run if it you load it and the script has already run before this time... |
|
Coolness: 2604105
| Ok the top 10 posters are now created when you click on the button so it will always be up to date. Good fun with indexes allows the process to run 15x faster (seriously)... |
|
Coolness: 66635
| I love when people just discover indexes.
The look on their face when their database performance improves 100+% is great |
|
Coolness: 2604105
| I didn't just discover them... I had 3 indexes already but I didn't have one for the author since I didn't think it was needed but I was wondering why it took 20 seconds to make the top 10 list and realized it was because the top 10 needs an index for author... A board with 50,000 messages in in definately needs some kinda index for date or nothing would load hehe... |
|
Coolness: 66635
| every table that has more than a few records should have an index man. |
|
Coolness: 2604105
| No... tables smaller than 1000 records it will slow things down in most cases... |
|
Coolness: 58060
| alex is way cool cause he knows more about indexes |
|
Coolness: 2604105
| You wish... |
Top 10 Posters
Vous devez être connecté pour soumettre une réponse.