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 temporary table, perhaps in ram memory, where you store
the GUIDS, e.g.
CREATE TEMP TABLE MyGUIDS(GUID);
Then pull them all out of the people table all at once with:
SELECT * FROM People
WHERE GUID IN (SELECT GUID FROM MyGUIDS)
ORDER BY XXXX
[opinions mine, not my company's]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
