Re: Slow update

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

How many records are you updating? How much data per row? Is it updating
the entire table or just the rows you changed? What is the connection speed
between you and the SQL database?

"Geoff Jones" <nodamnspam@xxxxxxxxx> wrote in message
news:4321b4b4$0$3623$cc9e4d1f@xxxxxxxxxxxxxxxxxxxxxx
> 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
>


.

Relevant Pages

  • Re: Updating Database Prob
    ... I'm having some problems with updating an SQL Database with modified ... > program the changes that I made have gone, and it's the original data ... a dataadaptor and a dataset. ... some sort of sql statement the dataadaptor can apply on updating. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Edit data in a dataset datatable column automatically
    ... So you can handle event of datadapter (updating) where you can finally set ... "Homer" píše v diskusním příspěvku ... updating my sql database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Updating Database Prob
    ... I'm having some problems with updating an SQL Database with modified ... I got the code from a Wrox book, ... Could someone please help as I am at the end of my tether with this one!! ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Saving a dataset to a different database
    ... deleting any of the datarows that will not be ... of the dataset - deleting any rows from the SQL database that will be ... updating data to a remote sql database from data entered into a local ...
    (microsoft.public.dotnet.framework.adonet)
  • Saving a dataset to a different database
    ... updating data to a remote sql database from data entered into a local ... hardcoding the insert and update into the webservice is not an option. ... I have tried to manually set the state of a row so that I could use the ...
    (microsoft.public.dotnet.framework.adonet)