On 5/29/06, Mikey C <[EMAIL PROTECTED]> wrote:
I am using a web front end to display paged results. I need to tell the
user how many records there are in total, how many pages and which page they
are viewing.
I would like to use the LIMIT keyword to restrict the result using the two
This problem is as old as data processing. The "page N of M" situation
which requires that the entire data set be read to get M. Once you have
read the entire set you have many options on how you handle your window
on that dataset. You could use local storage for it all or take
advantage of
To perform a count one has to read the entire dataset regardless. Why
not implement your logic within your own program, using prepare and step
and ceasing to unload data from the columns when you hit your predefined
limit?
JS
Mikey C wrote:
Hi,
I think this has been discussed before, but I
"A. Pagaltzis" <[EMAIL PROTECTED]> wrote:
>
> At the same time, to my knowledge, a query which has an `ORDER
> BY` clause always has to produce all results before it can apply
> a `LIMIT` to the result set, so at least in that case, what you
> want should be possible.
>
Depends. SQLite will
* Mikey C <[EMAIL PROTECTED]> [2006-05-29 17:10]:
> Do you imagine Google loads 8 billions records into memory when
> the user is just viewing 10 results in page 5 after a broad
> search?
You can’t ask Google for more than the first 1,000 hits on any
search. (Go ahead and try.) There is a reason
I don't think you really understand what I'm trying to say.
Web based systems require paging that does not iterate through all records.
What is required is a means to LIMIT the results read from the database but
at the same time know how many records WOULD have been returned if the query
was
Hi,
I think this has been discussed before, but I can't find a good solution so
I'll post it again to see what people think.
Here's the problem. I have a large number of records in a table, which
contains many columns. Hence a large amount of data.
I have a SQL query that filters the results
7 matches
Mail list logo
