1 Reply Latest reply: Dec 7, 2009 3:22 AM by Laurenz Albe RSS

    database optimisation ressource (for expert only :) )


      Juste a (big) question,

      we want to migrate our application from (linux code-grep, cut, wc.....cammande) to JAVA or PRO C
      the application takes on input flat files (4 flate file per minutes) each file containes 100.000 lines to reformate with grep command and then load them into a partitionned database 10g

      what do you suggeste me you experts to implement for the best use of my database

      solution 1 : the use of java code rather then linux code
      solution 2 : the use of C /pro C code rather then linux code and java code
      solution 3 : the use of external tables in oracle (consider my flat files as external table) and contain do all the trasformation with native SQL code rather then linux code and java code and C code

      I realy need your help,
      we don't want to use teradata cause of the expencive price, and we ask me to make optimum developpement

      Tks in advance