posted 15 years ago
Hi all,
I have 12 threads polling one database table. When the program is actively running, the response is very slow in Query Analyzer for a select statement querying the same table. Anybody know what is the cause of that ? and any ways to prevent this ?
Am I updating the database table too frequently and eat up all the resources 'coz the threads are updating the status column of the result set.
Thanks in advance.