Subject Re: [firebird-support] Re: How to handle a large 'IN' clause?
Author Ann W. Harrison
phil_hhn wrote:
> It seems creating/inserting the data into the temp table is what kills
> it (and yes, a prepared statement was used).
> Should this be so??

Maybe not, but there's a lot of i/o involved in creating and populating
a temporary table (not to mention using up table id's and artificially
aging your database). I/O is expensive.