kasinadh
December 2nd, 2003, 11:46 AM
Trying to move an application(MFC), that uses ODBC-recordsets to access data in MS Access today, to Oracle. I have a couple of questions.
1) Whats the best way to map to tables in Oracle, CRecordset or other! Currently it is CRecordset.
2) Currently, Data from 3 tables in Access(join) is read into a listbox and displayed on screen( Total records/table = 200,000 but selecting @1000 for every screen display). What can be done to take advantage of moving to Oracle, and how can it be made faster.
3) Can bulk updating feature help, if so, where can I get information on how?
Any help/ideas on this is greatly appreciated.
1) Whats the best way to map to tables in Oracle, CRecordset or other! Currently it is CRecordset.
2) Currently, Data from 3 tables in Access(join) is read into a listbox and displayed on screen( Total records/table = 200,000 but selecting @1000 for every screen display). What can be done to take advantage of moving to Oracle, and how can it be made faster.
3) Can bulk updating feature help, if so, where can I get information on how?
Any help/ideas on this is greatly appreciated.