Re: Q: Slow update

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Geoff Jones wrote: 
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



It would help to have an understanding to what you are doing and how you are doing it....

-  Are you working over a lan/dialup/local machine?
-  What is the update statement you are using to do the insert.
-  How many records are in the table
-  What indexes do you have in the table.

Chris
.

Relevant Pages

  • Q: Slow update
    ... 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. ... the table in a DataSet and I want to update it to the SQL database which the ... I'm using a data adaptor and the update command ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Writing value to datetime field in SQL database in dd/mm/yyyy format
    ... Bernie Yaeger ... > I'm hoping i'm posting to the correct newsgroup - this question involves ... > this field need to be written back to a SQL database. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: [PHP] MSSQL_CONNECT problem
    ... Subject: [PHP] MSSQL_CONNECT problem ... Sorry for "top posting", that's how my email client sets up the reply... ... Either way - I tried adding a DNS on the web server, ... SQL database, and that connection works...but the code I'm using from ...
    (php.general)
  • Re: DDE Between Access ADP and B-Coder Pro not working in win2k
    ... > Thanks for the response. ... >the SQL database that we created to hold them. ... vendor for an alternative method of working with the printer. ... Microsoft Access Links, Hints, Tips & Accounting Systems at ...
    (microsoft.public.win2000.security)