>Does your SQL support a limit select statement?
>(mySQL does) Try:
>
>select * from Table limit x,y
>
>where x = starting row (0 being the first row)
>and y = the number of rows to return.
>If so:
>
>select * from Table limit 0,1
>
>should return only the first row
>
The problem is however, even though you only get the first row back, the
database still has to create the full result set before it returns the first
row. This is certainly true for Oracle and I suspect true for all SQL
compliant databases.
Regards
Roger
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
