Devart Forums

Gigi wrote: Hi we're trieing your oracle provider for load table that have 268 fields the source flow size is 6GB there is a fast mode to load this Data flow? what is?

tank you so much

Hi,
I try with Sqlloader but it isn't faster than OracleLoader probably I made a bad usage of oracleLoader my code is that

Code: Select all

        oraLoader.Open();
       
        for (int i = 0; i < rowsNumber; i++) 
        {
            oraLoader.SetValue("Field1", records[i].Field1);
            oraLoader.SetValue("Field2", records[i].Field2);
            oraLoader.SetValue("Field3", records[i].Field3);
            oraLoader.SetValue("Field4", records[i].Field4);
           	...
           	268 Fields
           	...
           	oraLoader.NextRow();
        }

      
        oraLoader.Close();
      

in this code I have an istance of oracleLoader(oraLoader) and a collection of record(records).
It's correct ?
I am interested at your product and I am sorry if I offend you I did not want

Thanks a lot and sorry for my english

Gigi