"Leonardo Francalanci" <[EMAIL PROTECTED]> wrote on 22/06/2004 14:26:54:
> > A non-streaming connection will place the resultset in memory. With large > > tables you can run out of memory and the application will stop. > > > I get only 1 record per time (accessing by key), so I don't think > it could be an issue. It looks as if you are being over-complex anyway. Isn't what you want SELECT * FROM PARTITIONED_B ORDER BY RAND() LIMIT 1 ; which picks a single random record. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]