Tito Ciuro wrote:
Assume the following scenario: I store people in a table, like this:
People
ROWID, idx
GUID, idx
First, idx
Last, idx
Email
...
In the app, the user can select People GUIDs from different sources
and then retrieve the info from the database. The
Hi Donald,
On May 2, 2007, at 11:25 AM, Griggs, Donald wrote:
The ROWID is indexed implicitly I believe, so it may be slowing things
slightly if you index it explicitly.
Yes, I was aware of that, thanks for the heads up.
Regarding: "What if I have, say, 500 to retrieve?"
You can create a
Hello,
On May 2, 2007, at 11:11 AM, P Kishor wrote:
On 5/2/07, Tito Ciuro <[EMAIL PROTECTED]> wrote:
When you say "speed things up," is it not fast enough yet? Numbers
would be helpful.
I've just tested it and the query is *very* fast. I was just
wondering whether this type of query looked
Hi Tito,
People
ROWID, idx
GUID, idx
First, idx
Last, idx
Email
...
The ROWID is indexed implicitly I believe, so it may be slowing things
slightly if you index it explicitly.
Regarding: "What if I have, say, 500 to retrieve?"
You can create a
On 5/2/07, Tito Ciuro <[EMAIL PROTECTED]> wrote:
Hello,
Assume the following scenario: I store people in a table, like this:
People
ROWID, idx
GUID, idx
First, idx
Last, idx
Email
...
In the app, the user can select People GUIDs from different
5 matches
Mail list logo