SOS OracleLoader

SOS OracleLoader

Postby luigi.ferrillo@tiscali.it » Tue 24 Oct 2006 07:50

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
luigi.ferrillo@tiscali.it
 
Posts: 5
Joined: Mon 23 Oct 2006 12:39

Postby Alexey » Tue 24 Oct 2006 08:12

luigi.ferrillo(@)tiscali.it, please describe what you need or what is the problem. Who is Gigi?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

SOS Oracle Loader

Postby luigi.ferrillo@tiscali.it » Tue 24 Oct 2006 11:44

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
luigi.ferrillo@tiscali.it
 
Posts: 5
Joined: Mon 23 Oct 2006 12:39

Postby Alexey » Thu 26 Oct 2006 08:34

You may try Oracle SQL*Loader utility, but we don't think this would be faster.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

SOS OracleLoader

Postby luigi.ferrillo@tiscali.it » Thu 26 Oct 2006 12:18

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
luigi.ferrillo@tiscali.it
 
Posts: 5
Joined: Mon 23 Oct 2006 12:39

Postby Alexey » Thu 26 Oct 2006 12:55

Yes, your code is correct.
For more information about OracleLoader please consult our help documentation.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby luigi.ferrillo@tiscali.it » Thu 26 Oct 2006 13:12

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
luigi.ferrillo@tiscali.it
 
Posts: 5
Joined: Mon 23 Oct 2006 12:39

Postby Alexey » Thu 26 Oct 2006 13:23

You should try this yourself.
We cannot recommend a tool better than Sql*Loader.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

SOS OracleLoader

Postby luigi.ferrillo@tiscali.it » Thu 02 Nov 2006 13:16

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
luigi.ferrillo@tiscali.it
 
Posts: 5
Joined: Mon 23 Oct 2006 12:39

Postby Alexey » Thu 02 Nov 2006 14:43

Thanks for your appreciation.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle