S
steve
Hi all,
I have a problem in that I have written a .Net 2 application for a
customer that performs significant amounts of manipulation - 250,000
records manipulated and updated with combination of update and select
into commands.
The issue is that it works fine on my old slow development 2003 server
with SQL 2005, and also on my home 2003 SBS with SQL 2005 too. Yet on
the customer PC (the important one obviously) whilst other pieces of
the appliation are significantly quicker (it is a new quad processor
high spec machine), the key update routine times out when updating
large qtys of records which my slow servers munch through.
I've checked the IIS settings and timeouts but no difference. THe
customer has even rebuilt the server after we could find no difference
- yet same issue. It is a killer when the project is technically
finished but it just won't run on the customer server!
Any help much appreciated.,
Steve
I have a problem in that I have written a .Net 2 application for a
customer that performs significant amounts of manipulation - 250,000
records manipulated and updated with combination of update and select
into commands.
The issue is that it works fine on my old slow development 2003 server
with SQL 2005, and also on my home 2003 SBS with SQL 2005 too. Yet on
the customer PC (the important one obviously) whilst other pieces of
the appliation are significantly quicker (it is a new quad processor
high spec machine), the key update routine times out when updating
large qtys of records which my slow servers munch through.
I've checked the IIS settings and timeouts but no difference. THe
customer has even rebuilt the server after we could find no difference
- yet same issue. It is a killer when the project is technically
finished but it just won't run on the customer server!
Any help much appreciated.,
Steve