Re: Batchupdates performance

When you say 35 "new fields" , do you mean you changed the value of 35
existing columns in 500 rows or do you mean you added 35 "new" columns to an
existing row ???

BatchOptimistic updating can be a bit slow but yours sounds very slow. It
may be an Oracle issue .. allocating additional space, poor indexing
schemes. When you do batch optimistic locking, you need an ***primary key***
selected in your dataset. That way the DB can go immediately to the proper
row in the phsysical database and update the data. When you dont supply a
unique key (primary index or primary key .. depending on the DB), then the
DB engine must take each record that you have in your data set and read from
one end of the table to the other to determine which row was the row that
you wanted to update. .... Then, he takes the next row in your dataset and
once again, reads from one end of the table to the other to see which row
should receive the updates ...get the picture ???? when you create your
dataset do something like this .. 'select id, name, address, ssn from
tablexxx where name like '%A%'

id (in the select statement) is the primary key defined for the table. By
definition, primary keys are "unique keys".

HTH

Del


.

Relevant Pages

  • Re: Move to First Record on Sub Form
    ... Using the AfterUpdate event of your primary key control on the main ... If I then select another primary key from the main form, the sub form ... How do I code an event to open the data set to the first record? ...
    (microsoft.public.access.forms)
  • Re: Schema Pri Key and Dataset
    ... > defined in the XML schema, but when I fill the data set it doesn't seem to ... Did you write this XML Schema fragment, or did you get this from a call ... AFAIK, DataSet serializes the ... your GalleryId column as its primary key. ...
    (microsoft.public.dotnet.xml)
  • Re: how do i get the value of my primary key in datagrid?
    ... > i'm wondering how can i get the value of primary key in datagrid. ... but not see the pk in the grid? ... you can include the column in your data set and set the width of the ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Database suggestion
    ... PRIMARY KEY ... 'Example Data Set 1'); ... An example of selecting data from Data Set 1: ... Some examples of selecting the sum of data from multiple sets: ...
    (comp.lang.php)
  • Re: Database suggestion
    ... PRIMARY KEY ... 'Example Data Set 1'); ... An example of selecting data from Data Set 1: ... Some examples of selecting the sum of data from multiple sets: ...
    (comp.lang.php)