06-11-2011, 04:55 PM
I am looking for a solution that can fetch records from DB table with less impact on performance.
The requirement is to extensively use around 80 DB tables(Database: Oracle). Instead of fetching DB records one after other, I want some mechanism to fetch entire DB table once and store in temporary variables. For example, RecordGroups concept in SQL does this job.
Note: A record group is an oracle forms data structure that has a column/row framework similar to a database table.
The requirement is to extensively use around 80 DB tables(Database: Oracle). Instead of fetching DB records one after other, I want some mechanism to fetch entire DB table once and store in temporary variables. For example, RecordGroups concept in SQL does this job.
Note: A record group is an oracle forms data structure that has a column/row framework similar to a database table.