SOS OracleLoader

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
luigi.ferrillo@tiscali.it
Posts: 5
Joined: Mon 23 Oct 2006 12:39

SOS OracleLoader

Post by 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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 24 Oct 2006 08:12

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

luigi.ferrillo@tiscali.it
Posts: 5
Joined: Mon 23 Oct 2006 12:39

SOS Oracle Loader

Post by 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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 26 Oct 2006 08:34

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

luigi.ferrillo@tiscali.it
Posts: 5
Joined: Mon 23 Oct 2006 12:39

SOS OracleLoader

Post by 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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 26 Oct 2006 12:55

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

luigi.ferrillo@tiscali.it
Posts: 5
Joined: Mon 23 Oct 2006 12:39

Post by 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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 26 Oct 2006 13:23

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

luigi.ferrillo@tiscali.it
Posts: 5
Joined: Mon 23 Oct 2006 12:39

SOS OracleLoader

Post by 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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 02 Nov 2006 14:43

Thanks for your appreciation.

Post Reply