Hi!
I save 10 rows per second to a Access DataBase.
Data are copied to DataSet pro term, then I call Update fuction of
DataAdapter to refresh database.
code:
DataRow newRow;
newRow = dataSet.GPS.New Row();
newRow["distance"] = distance;
newRow["Longitude"] = Longitude;
newRow["Latitude"] = Latitude;
dataSet11.GPS.R ows.Add(newRow) ;
...
oleDbDataAdapte r.Update(dataSe t.GPS);
Update is very slow. At 10 row saving: about 0,07s
At 100 row saving: about 0,2s
Unfortunatelly, the program running break during Update.
Is the executing of Update really so slow?
I am looking forward to your answer.
*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*