Pauses with large selects

, perhaps a better way to loop through all the rows in a large table without building up a potentially huge temporary buffer somewhere. Thanks for your time, S. Lemmon - Before posting, please check: http://www.mysql.com/manual.p

Re: Pauses with large selects

elects. It's just a bit of a re-think since until recently, Informix had no statement like LIMIT and it's normal to simply close the cursor (finish() under DBI) once you've found what you're after. Thanks, S. Lemmon -