Q: slow update

From: "Geoff Jones" <nodamnspam@xxxxxxxxx>
Date: Fri, 9 Sep 2005 15:43:13 +0100

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

.

Prev by Date: Re: help with microsoft ADO control/True DB Grid
Next by Date: Re: help with microsoft ADO control/True DB Grid
Previous by thread: help with microsoft ADO control/True DB Grid
Next by thread: vb.net ado connection string problem?
Index(es):
- Date
- Thread

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: Index now option Windows search 4.0
... it's database of files on local hard-drives is incomplete for some reason. ... 'magnifying glass' icon in the taskbar? ... time to complete it's updating, until it was complete it too would be ... is this 'Windows Live Desktop Search' that you're ...
(microsoft.public.windowsxp.general)
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)