>Peter,
>
>seems the COM is the bottleneck. I've got some replies telling me about the SETS of the COM. SET COLLATE does affect the performance of the SELECT - SQL Command? What is its optimal setting?
>
>Thus, I tried to test another COLLATE setting (
SET COLLATE TO GENERAL), but the COM returns some
No Support for this interface error.
>
>What's going on?
>
>[]'s,
Check also if there is a difference in SET DELETED between the two environments.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)