Skip to Content
0
Former Member
Jan 04, 2008 at 06:02 AM

Most efficient method to process 2 million plus records from & to a Ztable

61 Views

Hi All,

My requirement is as follows:

There is a table which has 20 and odd columns, and close to 2 million records.

Initially only 5 or 6 columns will have data. Now the requirement is to fetch them and populate the remaining columns of the table by looking into other tables.

Looking for the most efficient method to handle this as the data count is huge.

There should be an optimum balance between memory usage and time consumption.

Kindly share your expertise in this regard.

Thanks

Mani