Skip to Content
0
Former Member
Feb 16, 2009 at 02:10 PM

reading high volume of data from DB

31 Views

I have 6 lakh DB records to read from SQL server at a given time.

From DB, data file & control file need to be picked up, combine based on data and should be sent to one DB.

What are the performance factors involved ?

How long does the processing may take?

What is the suggested system resources for this?

What is the guarantee of the message processing?

If anyone has faced this problem earlier, do let me know can PI handle such load?

Thanks,

Venkat.