The first option is expensive as all the rows are returned.
In the second option only the count is returned
Br
Purav
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
Alarcon Fabio
Sent: Thursday, September 28, 2000 3:47 PM
To: [EMAIL PROTECTED]
Subject: About JDBC
Hi friends I need your help, please. 1. How can I set the ResultSet"
scrollable? 2. What is more expensive to get the number of rows
from a ResultSet? a) int rows = 0; rs.last(); rows =
rs.getRow(); rs.beforeFirst(); b) with "SELECT count(*) ..."
Suggestions please.
Thanks in advance
Best regards
Fabio Alarcon Ortiz
Seguro Social de Salud, Lima - Peru
Gerencia Central de Desarrollo e Informatica
Gerencia de Sistemas
Phones : (51 1) 265 6000, 265 7000 Extensions 2356, 2357
Mobile : (51 1) 855 1393
ICQ : 11002875
email : [EMAIL PROTECTED], [EMAIL PROTECTED]
___________________________________________________________________________
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
___________________________________________________________________________
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
