>From: peter lin <[EMAIL PROTECTED]> > >The proper way to do this is to only return n number of rows. Typically >this is done with scrollable cursors. The driver you're using has to >support the feature. I don't see support for it in dbtags, so your other >option is to use stored procedures or prepared statements that handle >the cursor yourself.
If DBTags does not support this, how are other people doing this ? This is a basic functionality that I believe everybody uses. I think I will have to write a scriptlet if DBTags does not have it. >fetching tons of rows to only display 20 will limit the scalability of >your web application under load. That is what I thought. >Especially if your database server isn't beefy :) In actual fact I thought it is more of a problem with all the records being transfered over the network unnecessarily. Thank you for your help Peter. Soefara Redzuan. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>