modifying my db

[Guest]

hey all,

i have an Access Database with about 43,000 records in it. I need to take 2
or 3 columns and modify them and update the database.

currently what i'm doing is loading all into a dataset and making changes
and pushing it back up to the database. it seems kind of a long process about
20 min.

am i better off using Access Query or SQL Server query to modify the data or
is there a faster way in vb.net? All, i'm doing is formatting date fields and
concatenating 1 other field.

Please advise.

Thanks,
rodchar

 

[Joseph Ferris]

rodchar,

That seems to be a long time to process those changes. Do you have a
primary key assigned to the table or any other indices?

Joseph

 

[Guest]

yes i do have a primary key, but isn't 43,000 records a lot? Especially doing
a database update thru a DataSet?

 

[Graham Parker [MVP]]

Hi rodchar,

Have all the rows on your dataset actually changed?
If not you can get a new dataset based on the existing one, with only the
rows that have changed using the
ds.GetChanges method. It works in conjunction with another method called
AcceptChanges() and it returns
a copy of the changes from your DataSet that you can perform actions on.

Good Luck.
Graham Parker.

 

[Guest]

yes, all rows have a date that will need to be converted from *ISO format to
*USA.