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

from Crecordset class ..

I use RFX_Text of CMyRecordset:oFieldExchange .
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++(ATL,MFC) developer