Hi,
I ran test data on my development machine and it took 1 minute to
insert the data. Ran the same set of data on the server and took 5
minutes.
Check both database and everything is the same. I even copied the
production DB on my machine and it was taking still about 1 minute.
Look at the fragmentation, and all the numbers are better on the server
than my development machine so it should be faster.
In the application I put some timer and discover that the insert is
taking 0.015 ms on the server and 0 on the development. So the problem
is on the insert.
It is a Web application using ASP.NET.
Here are the spec of the computers:
Development: P4 HT 3.2GHz 1gig memory running WIN XP
Server: Xeon 2.8GHz 1.5Gig memory running WIN 2000 server
Any idea how I to pinpoint the problem? I'm not at the point of
thinking that it can be the hardware, but how to verify that?
Thanks
Frank
I ran test data on my development machine and it took 1 minute to
insert the data. Ran the same set of data on the server and took 5
minutes.
Check both database and everything is the same. I even copied the
production DB on my machine and it was taking still about 1 minute.
Look at the fragmentation, and all the numbers are better on the server
than my development machine so it should be faster.
In the application I put some timer and discover that the insert is
taking 0.015 ms on the server and 0 on the development. So the problem
is on the insert.
It is a Web application using ASP.NET.
Here are the spec of the computers:
Development: P4 HT 3.2GHz 1gig memory running WIN XP
Server: Xeon 2.8GHz 1.5Gig memory running WIN 2000 server
Any idea how I to pinpoint the problem? I'm not at the point of
thinking that it can be the hardware, but how to verify that?
Thanks
Frank
Comment