Comments

  • 1-4 of 4
  • Sreeram Venkatramani

    The plan is to use curl to involve the SOAP Service from within the PHP script.

    Regards,

    Sreeram V

  • Sreeram Venkatramani

    Hi Vlad,

    Thanks for the detailed response.

    We would like to build logging into the PHP Scripts to identify performance bottlenecks.

    Can you please us provide pointers on how to add custom logging to the Connect PHP Script. A reference to Oracle documentation or a piece of code showing how this is implemented will help us understand the approach.

    Regards,
    Sreeram V

  • Sreeram Venkatramani

    Thanks a lot for the detailed response, Vlad.

    We will check with Oracle Support on the Data Import Wizard performance that we are noticing on our site.

     

    We have quite a few Custom Objects to load and we have created many custom attributes on the Standard Objects. Also, the average number of attributes to load per Object is around 40-50.

    Based on your experience, do you still think Data Import Wizard will be able to load 1,000,000 records (CSV rows) in a single import.

     

    Regards,

    Sreeram V

     

  • Sreeram Venkatramani

    Hi Vlad,

     

    We have tried the out-of-the-box Data import Wizard. Infact, we are using the Wizard to load Objects where only a couple of thousand records need to be loaded.

    We have noticed that it does not perform well for loads more than 10000 records per CSV file. For bigger load sizes, the Wizard just hangs and the agent desktop application crashes eventually (after a long wait).

    And this number changes from Object to Object. For few Objects, we can load only 2000-3000 per file, using the Wizard.

    If the volume of data to load is 1 Million records, it becomes a painfully manual job to load hundreds of CSV files of 5000 (or 10000) records per file.

     

    So, we are looking for an alternate approach that is robust and can handle greater number of records per file.

    Regards,

    Sreeram V