Oh dear - I knew this would happen. I just outlined the basic concepts of my
results set solution. It was not meant as a detailed spec or anything. I
didnt want to bore everyone with the gory details.
The points you have made are all perfectly valid and have been resolved in
our implementation.
Basically various beans implement an IFindable interface where SQL semantics
such as 'uniqueness' and 'order by' have been handled. The architecture
allows the user to do some fairly complex queries.
I agree this is not really a JSP issue. Maybe further posts should go
offline.
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of David Wall
Sent: Monday, December 20, 1999 11:03 AM
To: [EMAIL PROTECTED]
Subject: Re: Large number of records in JSP !!!
> > 4. The user clicks the 'more' button
> > 5. The primary key value of the last row is sent to the server as a
> > parameter.
> > 6. The same query is sent to the server with the following pseudo WHERE
> > clause tacked on the end
> >
> > WHERE primary_key_column > 'primary key value of last row in results'.
This is not really JSP oriented, but a general problem with online system
that uses SQL. The above solution only works if the query is simple enough
that the order of the rows returned also matches the primary_key_column
value. With SQL, once you get into ORDER BY and the like, you are not
likely going to benefit with such a solution. Also, the primary key in many
SQL databases are not classic "sort" keys anyway, since they are unique keys
that are often serial numbers, timestamps or the like. There's a basic
taboo about having primary keys that have semantic meaning rather than just
being unique IDs.
David
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
