Hi Mike,
>There is a differnce in the write speed and read speed. The write takes pace about 3 times faster than the read.
That's unusual. Normally, it's the write operation that is slower than the read, especially with transactions being involved. Do you have any columns that are memo fields or character fields with more than 254 characters that are not needed in the conversion? If so, you should replace SELECT * with SELECT field list and omit these fields.
--
Christof