Posted by DA Morgan on 08/16/06 19:48

Volks wrote:
> Hi,
>
> It takes 4 minutes to insert 40 000 records on a SQL Server and 40 sec
> on an other SQL Server. The slower run on windows 2000 terminal server
> and the faster on windows 2000. The slower The slower have 2 Go of
> ram, the faster 512 Mo!!!
>
> How to diagnostic what's going wrong on the slower server? I can't
> change the application who do the insertions.

That is amazingly slow. Using a different commercial database product,
on my slightly anemic IBM ThinkPad (2GB RAM) I just id 40,000 inserts
in 0.14sec.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

[Back to original message]