Colin Manning <[EMAIL PROTECTED]> wrote:
> Hi
>
> Assume I have a simple table for a phone directory - names, addresses, and
> phone numbers etc.
>
> Then assume this is a vast table with many millions of records, and that
> there are indices on name, phone number, etc.
>
> Then assume I'm
On 7/17/07 5:13 PM, "Colin Manning" <[EMAIL PROTECTED]> wrote:
>
> Not a problem. I can use "SELECT * FROM pb ORDER BY name LIMIT x,y" etc as
> my user pages up and down the list, or drags a scrollbar.
>
> Next, assume the user wants to jump to a specific record in the list, or to
> (say)
First, think about using FTS2 for your text lookup instead of using LIKE
and having to perform row scans.
Think about changing your logic to just read from the database instead
of blowing out your memory by holding the database on disk, then in disk
cache and again in application memory. If
Colin Manning wrote:
Hi
Assume I have a simple table for a phone directory - names, addresses,
and phone numbers etc.
Next, assume the user wants to jump to a specific record in the list, or
to (say) the first entry for a specific name.
How do you do this with sqlite, without forcing the
Hi
Assume I have a simple table for a phone directory - names, addresses, and
phone numbers etc.
Then assume this is a vast table with many millions of records, and that
there are indices on name, phone number, etc.
Then assume I'm writing an app that displays the entire directory in a
5 matches
Mail list logo