SOS OracleLoader

[[email protected]]

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

[Alexey]

luigi.ferrillo(@)tiscali.it, please describe what you need or what is the problem. Who is Gigi?

[[email protected]]

I try to load a Text file(6GB) in a table(268 Fields) and I use oracleLoader class but loading operation is very slow.exist a faster method to do that?

Thank you

P.S. Gigi is my friendly name

[Alexey]

You may try Oracle SQL*Loader utility, but we don't think this would be faster.

[[email protected]]

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

[Alexey]

Yes, your code is correct.
For more information about OracleLoader please consult our help documentation.

[[email protected]]

Sorry can i do anouther question?
If the code is correct, how many time I need to load the File(6GB) may be less then 50 minutes? this is the time that I have if I use Sql*Loader

best regard Gigi

[Alexey]

You should try this yourself.
We cannot recommend a tool better than Sql*Loader.

[[email protected]]

I have made various tests with your software and have found that in order to load 9000000 records with oracleLoader 40 minutes are employed and is an optimal result. I make my more felt excuses to you and I assure to you that I will buy OracleDirect.net. I hope that we will continue to work together and that you will continue to being therefore available.

Best regard Gigi

[Alexey]

Thanks for your appreciation.