Re: Slow update
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxxx>
- Date: Sat, 10 Sep 2005 10:20:53 -0700
Update speed really depends
more on what you're asking SQL Server to do--not how fast you ask it. I've
performed reasonably fast updates from a 1200 baud modem (Dallas to Redmond)
where the speed was 80% of the speed of a LAN. Other factors to consider
include:
1) What
is the server doing besides SQL? Is it a print server too? Is it running
reporting services? Is the server hosted on a workstation running Office
applications? Is the server running a screen-saver or a game?
(seriously)
2)What
other SQL is the server being asked to do? Are there a thousand other clients
trying to query or update rows? Are these clients locking/blocking rows that
your update needs?
3) What
kind of volume are you asking the server to change? If it's 3000 rows, are all
of these being changed at once? If it's 3000 rows, where did they come from? Did
they come from another data source? If so, why aren't you using a bulk copy
utility?
4) What
is "slow"? Is it seconds/record? minutes/record or what?
5) How
much RAM does the server have? How much is dedicated to SQL Server?
6) Does
the target table have an index? How many? Too many indexes can slow down updates
while too few can slow down queries.
You say you're a novice at
this. What have you read on the subject? There are a lot of ADO.NET and SQL
Server books (I know, I wrote several).
Consider that SQL Server
can support thousands of users and some of the fastest processing in the
industry. Even a lightweight rig can support hundreds of users with very little
resources--assuming the application is written correctly and the database is
designed properly. Do the Visual Studio/VB wizards generate efficient code?
Nope, but it's a good staring point.
hth
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Geoff Jones" <nodamnspam@xxxxxxxxx> wrote in message news:4321b4b4$0$3623$cc9e4d1f@xxxxxxxxxxxxxxxxxxx...
> Hi All>
> I hope you'll forgive me for posting this here (I've also posted to ado site
> but with no response so far) as I'm urgently after a solution.
>
> Can anybody help me? I'm updating a table on a database i.e. I've modified
> the table in a DataSet and I want to update it to the SQL database which the
> table originally came from. I'm using a data adaptor and the update command
> and it works BUT it is soooooooooo slow!!! Can anybody tell me of any
> techniques to speed it up?
>
> Thanks in advance
>
> Geoff
>
>
- Follow-Ups:
- Re: Slow update
- From: Geoff
- Re: Slow update
- References:
- Q: Slow update
- From: Geoff Jones
- Q: Slow update
- Prev by Date: Re: ListBoxes and Drag and Drop
- Next by Date: Re: Determine system's dpi setting
- Previous by thread: Re: Slow update
- Next by thread: Re: Slow update
- Index(es):
Relevant Pages
|
Loading
