I have a C++ application that inserts a lot of records in a SQL Server
7 database. It inserts around 100000 records a day. This is done with
ExecuteSQL and a normal statement like : Insert into Vis (origin,
valid, val) values (1,1,1000) .....
Every second hour a cleanup statement is issued.This statement should
delete every record that is over 50 days old... The delete statement is
also executed via ExecuteSQL on a CDatabase object...
After the system has been running for 51 days, the delete statement has
some records to delete, and it takes quite a while to delete the
approx. 100000 records... This is not a problem.. The delete statement
looks like this : delete from vis where creationtime < [some date 50
When the delete statement runs, I start getting timeouts in my C++
application's insert statements. How can I fix this problem?? I guess
it is a locking problem, but records with a Creationtime over 50 days
ago shouldn't be locked by an insert statement.. I don't use any sort
of keywords in my statements, it's just pure SQL, do I need to use some
kind of transactions? Setting a higher timeout time is NOT an option..
Sent via Deja.com http://www.deja.com/
Before you buy.