performance mySQL 5.0.11

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

Using LIMIT on large tables slows Queries down to a crawl when using  
like comparisons  (I understand that there is a fix in the beta  
release) but what I am wondering is whether you all think that there is  
a problem in returning a record set of say 10,000 rows and using a  
foreach loop to display just a few of them) ie doing the limiting  
within the PHP realm?


Ps I am offline for a few days so if I dont reply to the thread it is  
not out o rudeness ;-)

Re: performance mySQL 5.0.11

sometimes MySQL isn't the problem, but the rendering of the php/html on screen  
is a problem (==time consumer).

See the difference when using "ob_start();" at the beginning of the php script.
worked for me.

Richard Hulbert wrote:
Quoted text here. Click to load it

Site Timeline