Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

UPDATE & INSERT speed improvement question

Hello,

I'm working on a project which carrying a large scale of database (over 5 millions records).
I'm looking for a way to improve the communication speed with the SQL server in any way that i can find useful.

The main slowing reason that i have encounter is the INSERT and UPDATE command that can be processed for more then 2 minutes and this amount of time is unreasonable.

can anyone please advise how to do a different process method?

thanks,
Leo S
[508 byte] By [lior3790] at [2007-11-11 9:49:57]
# 1 Re: UPDATE & INSERT speed improvement question
http://www.google.com/search?q=sql+server+optimization
http://www.google.com/search?q=sql+server+performance+tuning
Phil Weber at 2007-11-11 23:43:35 >