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 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
Thank you very much,
-- Tito
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------