AlexK wrote:
> Finally, to address some comments Billy made. I know the select part
> of the query runs slowly, but I do not know if the insert is running
> slowly as well. I'm not sure how to test that. If you have any advice
> as to how to give you more info, I would be glad to do it.
Hm. would a select count(*) ... retrieve the same amount of data
the insert into ... select retrieves?
Also, you could first insert into a_temp_table select... and then
insert into your_real_table select * from a_temp_table in order to
test the insertion speed.
Lota of Greetings!
Volker
Received on Mon Jun 13 2005 - 12:47:37 CDT
