24 messages in com.mysql.lists.javaRe: JDBC OutOfMemory No Way mm Driver
FromSent OnAttachments
Arun Singh09 Nov 1999 00:23 
Mark Matthews09 Nov 1999 05:05 
Adam Ellwood09 Nov 1999 18:44 
Mark Matthews01 Dec 1999 13:11 
Terrence W. Zellers01 Dec 1999 13:16 
Tim Endres01 Dec 1999 13:19 
Frank Morton01 Dec 1999 13:27 
Mark Matthews01 Dec 1999 13:35 
Tim Endres01 Dec 1999 13:49 
Frank Morton01 Dec 1999 13:58 
zheng li01 Dec 1999 14:55 
Tim Endres01 Dec 1999 15:04 
Bart Locanthi01 Dec 1999 15:10 
Douglas A. Capeci01 Dec 1999 19:16 
David Wall01 Dec 1999 19:51 
Bart N. Locanthi01 Dec 1999 23:03 
Mark Matthews02 Dec 1999 05:19 
Terrence W. Zellers02 Dec 1999 06:25 
Frank Morton02 Dec 1999 09:09 
Frank Morton02 Dec 1999 11:04 
zheng li02 Dec 1999 12:25 
Praburam Conjeevaram02 Dec 1999 13:20 
Duane Gran02 Dec 1999 15:36 
Michael Widenius03 Dec 1999 02:50 
Subject:Re: JDBC OutOfMemory No Way mm Driver
From:David Wall (dwa@myEastside.com)
Date:12/01/1999 07:51:39 PM
List:com.mysql.lists.java

Or you could use the MYSQL feature of LIMIT on a select that lets you pick the rows returned starting from row M for N rows. I suspect that the efficiency of this may not be that great, but if you consider that most people will not actually iterate over the 1,000,000 rows, it probably doesn't matter much, and you can retrieve only one "page" of rows at a time.

David