How to data retrival make fast in VC++

[aloktambi]

i make one program for ivrs purpose.in which for database connectivity i use CRecordSet class fuction .in which i access 6 TABLES at a time for data manipulation. at this time cpu goes 100% and upto 15 seconds exe hangup.so another user dont able to access this exe file .so plz tell me can i make data retrival fast by any other method

[peiman]

Hi I suggest u to use another Thread for database retrival while ur main msg loop handle user and system msgs. also if u make a single QUERY for 6 table if it is possible it make ur jobs faster. Bye:)