none
Database read delay in ADO.NET RRS feed

  • Question

  • Hi Team,

    We are performing performance test on a .net 3.0 application that uses SQL Server 2005 database. There are 700 users accessing the application in the test.

    I want to control the delay of read requests to database, i.e, there should be a difference of 10 millisecond before passing two read requests to the database. I would like to add this as part of the application (in production); not only to the load test. How do we achieve this with ADO.NET? Please share your thoughts.

    Thanks

    Lijo

    Tuesday, April 12, 2011 11:47 AM

Answers

  • I think it sounds how windows system deal with the message queue. 

    Can you create query task list, the all queries are added to the list (the list should be singleton). When the list has just 1 item, then start a separate thread. If the list has more than 1, then no need to create another separate thread.

    This separate thread just loop through the list and execute the query, inside the loop sleep for 10ms. Delete the query from list once the query is done.

    When the list is empty, the thread can be stopped and removed.

    It is just a very rough idea popped into my head, so not quite sure it is doable.

    Good Luck

     

    Tuesday, April 12, 2011 1:36 PM