0 Replies Latest reply: May 14, 2014 3:01 PM by jfk RSS

    Best strategy to upload a big data file and then to insert in db the content

    jfk

      Hi,

       

      Here's our requirement. We have a web business application developed on JSF 1.2, JE66, WebLogic for application server, and Oracle for the data back end tier. We need to upload big data files (80 to 100 Mb) from a web page, and persist the content in database tables.

      What's the best way in terms of performance to implement this use case ? Once the file is uploaded on server a command button is available on the web page  to trigger a JSF controller action in order to save data in database.

      Actually we plan to keep in memory the content of the http request, and call insert line on each line of the file. But i think it's bad and not scalable.

      Is is better to write the file on server's disk and then use multiple threads to send the lines to the database ? How to use multi threading in a JSF managed bean ?

       

      Thanks