Reading Large data by file object - Portal time out ?

[Former Member]

What is best way of reading a file like excel which has thousands of records and sending as input to Function Module.

Example:

If i have records of 20,000 students(name,no,class) in excel sheet.

User will upload the excel sheet through file object in webdynpro view.

Data in excel file needs to be read one by one and sent to function module.

OR

submit all the data at ONCE as input to function module

i suspect there might be portal time out.

Any one encountered such scenerios.

[Former Member]

Hi Raghu

For performance reasons not only in SAP, in all the web tecnologies you shouldn´t upload a file for transactions for insert, upload, delete or etc... by web, my suggestion is that you put this excel file in some place in your path and then some background process run for send this data to the funciton module. Remember that a web interface has been designed to be fast and no for batch process. The process that you want to run can affect seriously the memory in your web server and the will be very slowly.

I hope, helps you.

Josué Cruz