The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Should a 50k row query take 59-304 seconds?
So I come home from classes and I see that bluehost has shut me down because I've been quote on quote using too many of their system resources.
I have a forum that at most has maybe 30 people on (including both members and guests). I'm looking at the sql_slow_queries log and I see a certain query taking anywhere from 59-304 seconds to execute? This is part of a rating mod that I have installed, and I've never had any problems with it before. Out of nowhere do I see this being a problem in the log. Is this a possible issue with my code, or is this bluehost having server hardware from 1999? Here's an example Quote:
|
#2
|
|||
|
|||
I would uninstall the mod anything that has to examine that many rows has issues.
|
#3
|
|||
|
|||
Using a LIMIT will not make any difference in how long it would take to execute the query. It will only shorten the amount of data that needs to be transfered. The LIMIT is only applied after the rest of the query has been executed. SELECT, JOIN, GROUP BY & WHERE are all done first, maybe even using temporary tables to sort.
|
#4
|
|||
|
|||
Oh okay, because my host claims that the SQL was quering "billions" of rows...Must have been a bug in the code somewhere.
|
#5
|
|||
|
|||
He might be right. I never said he wasn't, and that actualy just fits in what i have posted.
PS Not literally billions, the number of rows involved are in the example you posted. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|