The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Optimize a SELECT code (vB code)
I'm having issues on my server with a huge amount of slow queries like this one:
PHP Code:
Only thing that changed is the threadid. I have query times of 20-50 seconds on each of these queries. It's bogging down the server. So how can that code be optimized further? What about separating the dateline ordering into a php based sorting (array sort). |
#2
|
|||
|
|||
I think it may be an issue with your mysql server and not really require optimization.
|
#3
|
||||
|
||||
What does explain say?
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|