performance mySQL 5.0.11

[Richard Hulbert]

Hi

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?

Richard

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

[Snef]

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:

Hi
>
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?
>
Richard
>
Ps I am offline for a few days so if I dont reply to the thread it is
not out o rudeness ;-)
>