> And a question... Are you trying to make this big query, and then split
the
> results to show a small amount of them in every 'screen'...
> because if so, what you need is PAGINATION, that is, to be able to split
> your big query into smaller querys (like altavista does to 'show' a
million
> hits... ten a page..)
But is there really any good scheme for pagination with an SQL DB? Some DBs
have a LIMIT clause, but still there's a good chance the entire result set
has to be retrieved before the subset is returned, unless the DB has nice
optimizations and the WHERE clause is on an indexed field.
David
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
