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.


Regards,


Ann