Two choices:
1) Write a stored procedure
- will still have to muddle through the rows at the beginning of
the result before it starts giving you what you want
- still database dependent
2) Use a DBMS that provides the START, LIMIT options for the SELECT
clause (like PostgreSQL)
- still database dependent
- works quite well (this is mature functionality)
- *only* retrieves those rows you ask for (you don't have to
wade through the ones you've already seen)
... if you really want to *just* bring back twenty rows out of 2
million, it seems that (2) offers the best solution. Yes, it's tightly
coupled to a given DBMS. That DBMS is open source, and quite good
though. (I'm nearly certain there are OS DBMS implementations other
than PostgreSQL that offer this functionality, but none come to mind.)
If database independence is your primary goal, I'd suggest you go with
something like OJB (http://jakarta.apache.org/ojb). You can utilize
"lazy loading" of dependent data to help stream-line your results (only
the PKs will be retrieved; full objects are materialized on access)
Regards,
Eddie
Ashish Kulkarni wrote:
>Hi,
>But is there a way to write some thing, which is
>database independent, so u can change the database
>without any code modification,
>what i am trying it using CachedRowSet, i load the
>resultset into a cachedrowset and then display it page
>by page,
>now only think i have to figure is, how can i load
>only few records in this rowset, like if i have 1
>million records, just load say 1000 records, iterate
>through them, if u reach end of cache load another
>1000, and so,
>since a user will never go through a process of seeing
>million records at a time, may be 1000 the max...
>most user will use some thing like "Go To" to point at
>a specific record in database,
>I hope this thing works out well
>Ashish
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
