Q: slow update



Hi

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: datagrid update command
    ... -i display it on a textbox on the form b4 updating the dataset ... >> hi sir ... > always cause error says that CType is not defined inmy namespace, ... > how can i update the database or the dataset without knowing the value ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Looping through a datagrid
    ... updating of the data when the request is posted back to the server. ... This is my> first attempt at creating a working Datagrid and having it update to a> database. ... I have> made some fields in the grid editable and want those changes to hit the> database at the same time with an update button that I have at the bottom of> the grid. ... >> Why would you loop through a data grid? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Please help with a serious issue
    ... be located for updating) they are both invoicing customers that are right ... are updating as well as the previous and next record as sort of a buffer i ... run to a local database and update each night to the server. ... record on a second try because the lock will be removed by the time the user has ...
    (borland.public.delphi.database.ado)
  • Re: Unable to update view in Sql Server 2000
    ... > and database-sql server 2000). ... > party component but I don't think the component is the problem. ... > happening is that I'm updating fields that are part of view. ... So it seems that something in the production database ...
    (comp.databases.ms-sqlserver)
  • Re: Access DB grows too fast.
    ... I may have been wrong in my original post in that the updating of an ... ADODB recordset causes the huge Access database. ... > and then adding to that recordset and then updating it every ...
    (microsoft.public.data.ado)