Hi
Are u using precompiled queries? If not try using it...
On 9/19/06, PY <[EMAIL PROTECTED]> wrote:
Hi All,
I have a problem about LIMIT & OFFSET profermance.
Due to the limitation of memory, I could not get all of the query result
at
a time.
In our soluction, we use the LIMIT and OFFSET to avoid the problem of
memory
issue.
we observed the performance of LIMIT & OFFSET, it looks like a liner grow
of
the response time. In our table, it only has 300~500 records.
Here is the dummy script
Create Table foo(id INTEGER PRIMARY KEY AUTOINCREMENT, x TEXT);
create index idx_foo on foo(x);
insert into foo(x) values('text001');
:
:
insert into foo(x) values('text300');
Select distinct x from foo LIMIT 20 OFFSET 0; Select distinct x from foo
LIMIT 20 OFFSET 20; Select distinct x from foo LIMIT 20 OFFSET 40; Select
distinct x from foo LIMIT 20 OFFSET 60;
:
:
Select distinct x from foo LIMIT 20 OFFSET 280;
Would you please help to tell me how to improve that?
Thanks for your great help.
Thanks,
VK
