On Fri, 10 May 2002, Gading wrote: > >Yes. This is one of the major advantages of using JSTL's (or DBTags's) > >database support. The "LIMIT" and "OFFSET" keywords aren't standard SQL, > >so using them can limit the portability of your application (and simply > >won't work if your database doesn't support them). On the other hand, > >when you use JSTL's <c:forEach> to page through results, or even using > >JSTL's <sql:query> with its 'startRow' and 'maxRows' attributes, JSTL > >takes care of the problem for you, and it is possible to write pages > >that are portable across different databases. > > Will it scalable and efficient to handle thousands of records?
That depends mostly on the database driver; JSTL simply passes the requests through. However, 'startRow' and 'maxRows' are, in the typical case, less efficient than LIMIT and OFFSET; you have a typical tradeoff, here, between performance and portability. (Using vendor-specific features can often improve performance at the expense of generality.) > Thanks for your reply. Btw, books from manning is not very common in > here (indonesia, but wrox does), is it "good" ? :-) You're not asking an un-biased party :-), but if you found a Manning book, you'd most likely be impressed very favorably by its quality. (I'm not sure what the best way to order a physical Manning book from Indonesia is, but for my book, we'll be making some related materials available through http://www.manning.com/bayern -- including a free distribution of all the book's examples. I encourage you to try it out there; some materials will be up as soon as next week.) Best, -- Shawn Bayern "JSP Standard Tag Library" http://www.jstlbook.com (coming this summer from Manning Publications) =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
