Time out in fast updation of sql server database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi all,
Myself using Sql server through mfc odbc , CDatabase class and a class
derived

from Crecordset class ..

I use RFX_Text of CMyRecordset::DoFieldExchange .
Now i have to update a particular field some 4000 times per min.

I did something like that .

CDatabase objdatabase;
objdatabase.openex(connection strign);//opens successfully

MyRecordSet objMyrecordset(&objDatabase) ;//object of a class derived from
CRecordset

In a function ..(which get called some 4000 time per minute)

{
objMyrecordset.Open(CRecordset::dynaset ,strOpenRecordSet);//seleting one
record at one time
......
do something with field value

objMyrecordset.Edit()
objMyrecordset.m_strField = Somenewval ;
objMyrecordset.Update();

objMyrecordset.close();

}

now for around 30 mts this works fine but after that time out (exception)
starts comming ,

and update stars taking much more time than before .My database only has
1500 records .

Please help wht to do???
--
amit bharadwaj
VC++(MFC) developer
.

Relevant Pages