| amit bharadwaj 2005-06-16, 8:23 pm |
| Hi all,
Myself using Sql server through mfc odbc , CDatabase class and a class
derived
from Crecordset class ..
I use RFX_Text of CMyRecordset::DoFiel
dExchange .
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::dyn
aset ,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
|