Updates are soooo Fun

Ok has anyone come up with any good ways to speed up updating in simple applications Not N-tier and such just a simple little application communicating over a network to a database, lets say an access database. Flat but wide file. Updates from the access front end of course take half the time but I have 200 users ;) working on the system and I would just like to speed it up from 20 seconds to 5. I know I would love to go sql but that is for another budget year and the problem is now.

Thanks

Anyone have any workarounds for the slow update issues.

PS Can we add spell check to the post screen please……

Answer this question

Updates are soooo Fun

Jeff King
I see two options:

1- Batch Update -- aggregate changes over a period of time and submit them all at once.
2- Worker Thread -- spin up an alternative thread to manage the update while keeping the UI responsive.
SPotam
I use the thread option to load in the first 150 rows and if they have more then that I thread it out and load the data. A tip from that is to set the datagrids datasource to nothing fill the dataset with the rest of the data and then set the datasourse back to the dataset this will drastically increase the speed of the load.

I was leery of this for the save because of the instabilities and the fact that the user thinks the record is saved but the application may still be saving the record.

I was also leery of the batch processing do to the fact that you could loose quite a bit of records. I guess I could write them to an xml file temp and then delete that file upon success.

I was hoping for more of a setting that will maybe let the jet engine perform the work and increase the speed by disconnecting the ado.net from the confirmation procedures.

I'm not sure I’m just fishing for ideas keep them coming
Updates are soooo Fun

Answer this question