My application based on MFC recordset class does a select query on a huge databse table (more than 200 00 000 rows) and does some calculation.
During this calcualtion it creates CTT*.tmp files in %TEMP% folder and the size of the file keep increasing. And my application gave exception once the the temp file reached around 2GB. I would like to know what are these tmp files and is there any limitations. I did some internet search and found that oracle client does creates these files but no information on the limitation.