Re: Batchupdates performance


"Del Murray" <Del.Murray@xxxxxxxxxxxxxx> wrote:
PS .. you read the whole table 500 times .. I'd say 3 minutes was pretty
quick :-)


Hi there

What I am doing is updating 35 fields for 500 records , its a good suggestion but I am including the key field in the select statement as well, however I am including it by default because the dataset I'm updating is based on a select * from x where etc etc so the primary key is included by default.

The initial updates are very fast cos the locate command uses the primary key as it's search so it zips along nicely, it's just the batch update command thats slow.
.

Relevant Pages

  • Re: Violation of PRIMARY KEY constaint...
    ... aggregate primary key made of two integers. ... My select command is 'select * from t' ... Before attempting any updates, I call t.Rows.Contains. ... as do most applications I have written in the past ...
    (microsoft.public.dotnet.framework.adonet)
  • Error in Adding New Record to Table
    ... I have a Form/Sub-Form that updates two tables. ... that are joined to create primary key for record search against both tables, ... The user's uses a command button to "Add New record", ... Exit Sub ...
    (microsoft.public.access.formscoding)
  • RE: How do I handle this??
    ... A primary key field must contain unique values. ... Microsoft Access MVP ... "Duane Hookom" wrote: ... weekly updates" which has no specific meaning. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: dog slow et al
    ... >> Windows XP Home SP2 ... >> Ad-Aware SE with latest updates found only 3 tracking cookies. ... In the Open box, type cmd, and then click OK. ... At the command prompt, type the following commands, and press ENTER ...
    (microsoft.public.windowsxp.general)
  • Re: Disabled HTTP PUT command since latest windows updates?
    ... Check if WebDAV has not been disabled by updates. ... > internals of iis. ... > HTTP PUT command to upload the necessary files. ...
    (microsoft.public.inetserver.iis)