none
Slow Database Update RRS feed

  • Question

  • Hi there

    I have a SQLExpress DB with a number of tables. Most are for user entry and that all works fine. I have 2 tables that are connected to datagridview. They are both feed data from a TCP connection. The feed sens on average 20-30 packets per second. The data comes in on a seperate thread and I do a BeginInvoke to populate the grids with the data. Each row of the table has about 15 columns. After each row is updated I do an Update() to write the changes back to the underlying DB.

    This is the problem. If I write the changes after each update, the processing of the incloming packets slows and the main thread becomes so busy that the interface is unusable. I tried not writting the data until the packets stop coming in, but it then takes a long time (about 10secs) to update the DB which is too long.

    Can anyone think of a way to update a DB that might be quicker?

    Thanks
    Dave

    Friday, June 16, 2006 1:29 AM

All replies