On 10/24/06, Da Martian <[EMAIL PROTECTED]> wrote:
For exmaple, Lets say I run a SQL statement (its a very heavy statement consiting of joins and subqueries). It returns 5000 rows. For speed I dont want to retrieve 5000 rows, I want to setup a list which shows that there are 5000 rows on the scroll bar, but only retrieves the first say 20 for display.
My solution was simpler but most people hate it. A list that's 5000 entries long will almost never be used by the user. Nobody has the patience to scroll through 5000 entries. Do like google does and fetch the first N rows of any result set and if there's more tell the user there's more and they need to refine their query. -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
