Jasper Potts wrote:
> The best solution I have so far is to create a selection table and write
> the select out to that and perform a join but the 100,000 inserts are slow.
How are you constructing this table? If you use batched inserts with
autocommit off, it should be fairly fast; I get 8000+ inserts per second
over larger data sets.
Can you move the selection list into the DB semi-permanently? Really,
the underlying problem is that you need to move a 100,000-item list to
the database on every SELECT.. if you can have the list "already there"
it's going to be faster.
-O