Hello Dave, Thank you. This works.
Kind regards Emmanuel > -----Original Message----- > From: Adrian Monea [mailto:[EMAIL PROTECTED]] > Sent: 20 January 2002 15:08 > To: 'Emmanuel van der Meulen' > Cc: [EMAIL PROTECTED] > Subject: RE: Understanding throughput with JDBC > > > Why not try to use > > SELECT * FROM MEMBERSHIPSTRACKING ORDER BY ACTIVITYTIMESTAMP DESC LIMIT > 0,50 > > It will have the same effect, and only the 50 results you need will be > built into memory. > > Regards, > Adrian. > > > > -----Original Message----- > From: Emmanuel van der Meulen [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 20, 2002 1:31 PM > To: MySQL General List; MySQL Java List > Subject: RE: Understanding throughput with JDBC > > > Hello Mark, > > Thank you for the note and feedback. BTW, it was not over a network. > Both on local PC. So all the time went into building the resultset in > memory. I'm surprised at the time that takes. > > Further to why I'm desirous to do this query, twofold. One I get the > record count (rows in the table); since realised there are other ways to > get he number of rows. For the second requirement I cannot see an > alternative. Not on this table, but on another where I keep a timestamp, > I'd like to get the 50 most recent inserts. So what I do is; (SELECT * > FROM MEMBERSHIPSTRACKING ORDER BY ACTIVITYTIMESTAMP DESC) thus get all > the rows, ordered desc on timestamp and then I have the most recent 50 > inserts. If anyone could assist me with this, I'd use other means, > rather than retrieving the full resultset. > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
