Re: Q: Slow update

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

Hi Chris

Sorry to you as well for the vague information in my earlier post. There are
about 3000 records and I'm using a 1Mb broadband connection. The update
command is via a command builder.

Indexes? Err, sorry, new to all this. Are you refering to the primary key?

Thanks for trying to help.

Geoff

"Chris" <no@xxxxxxxx> wrote in message
news:OZDDOwVtFHA.464@xxxxxxxxxxxxxxxxxxxxxxx
> 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

  • Re: Updating
    ... Geoff ... > No however doing it with SQL code is absolute no hell of a job using the ... >> Hi Cor ... >>> There will never been build a table in your database by a adonet command ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Fixed Length file to Database perfomance issues
    ... length of each field and storing them in a hashtable before populating the ... > field from an XML file that describes the length of each sequential field, ... > and them put them in SQL database. ... > 1) Generate a new command object with same name parameters as defined in XML ...
    (microsoft.public.dotnet.framework.performance)
  • Re: MAC address table help
    ... command to a SQL database, or at least a text file, ... My ultimate goal is to then take this data and incorporate it with our ... inventory system to help keep track of computers and multiple vlans ...
    (comp.dcom.sys.cisco)
  • Re: MAC address table help
    ... You may want to investigate how Netdisco does it... ... it's open source. ... command to a SQL database, or at least a text file, ...
    (comp.dcom.sys.cisco)
  • MAC address table help
    ... I am looking for a way to dump the output of the following ... command to a SQL database, or at least a text file, ... inventory system to help keep track of computers and multiple vlans ...
    (comp.dcom.sys.cisco)