List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:March 3 2000 6:46pm
Subject:Re: Loading a table into memory
View as plain text  
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
Thread
Loading a table into memoryDouglas Robinson3 Mar
  • Re: Loading a table into memoryWico de Leeuw3 Mar
    • Re: Loading a table into memory - Yikes!Douglas Robinson3 Mar
  • Re: Loading a table into memoryDan Nelson3 Mar
  • Re: Loading a table into memorysinisa4 Mar