In the last episode (Mar 03), Douglas Robinson said:
> Hello all
> I have a wee problem. I would like to read a table of
> indeterment size into memory. I would like to read it in chunks of
> say 100 records. The table look somethong like
>
> Create Table group (
> id int DEFAULT '0' NOT NULL auto_increment,
> name varchar (64));
>
> I could write:
>
> select * from group where id > 0 limit 100;
> select * from group where id > 100 limit 100;
What's the reason for doing it in 100-record chunks? Wouldn't it be
easier to open a cursor on "select * from group", and process all the
records in one go?
--
Dan Nelson
dnelson@stripped
