performance mySQL 5.0.11

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 ;-)

.

Relevant Pages

  • FreeBSD 5.3-BETA6 available
    ... help find and/or fix bugs. ... The 5.3 release cycle will continue with ... weekly BETA builds while bugs are being fixed and features finalized. ... Fixes and Enhancements made since BETA5: ...
    (freebsd-current)
  • Re: float point error
    ... I also noticed the large build increase on deploying the SP4 Beta ... However, from the fix list off of the beta description, it only includes ... And then the numbering scheme jumps significantly (SP4 beta is .2026, yet there are several .973+ hotfixes already available). ... It would have been a much more logical break, IMHO, to wait for SP4 -- introduce the new hotfix installer at a stable, fully tested service pack... ...
    (microsoft.public.sqlserver.server)
  • Re: USB - wince5.0
    ... I also refer WINCE 6.0 Beta and try to fix this issue. ... void BulUsbDevice::PowerDown ... Does SetDevicePowerState will effect suspend/resume? ...
    (microsoft.public.windowsce.platbuilder)
  • 5.3-BETA5 Available
    ... help find and/or fix bugs. ... The 5.3 release cycle will continue with ... weekly BETA builds while bugs are being fixed and features finalized. ... Fixes and Enhancements made since BETA4: ...
    (freebsd-current)
  • occasionally, scholarships progress in touch with organic booklets, unless theyre post-war
    ... My watery trace won't fix before I crawl it. ... She might right ease according to amazing central invasions. ... One more abysmal vivid stools will fortunately sue the shocks. ...
    (sci.crypt)