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
SOS OracleLoader
-
- Posts: 5
- Joined: Mon 23 Oct 2006 12:39
SOS OracleLoader
-
- Posts: 5
- Joined: Mon 23 Oct 2006 12:39
SOS Oracle Loader
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
Thank you
P.S. Gigi is my friendly name
-
- Posts: 5
- Joined: Mon 23 Oct 2006 12:39
SOS OracleLoader
Hi,
I try with Sqlloader but it isn't faster than OracleLoader probably I made a bad usage of oracleLoader my code is thatin this code I have an istance of oracleLoader(oraLoader) and a collection of record(records).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();
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
-
- Posts: 5
- Joined: Mon 23 Oct 2006 12:39
-
- Posts: 5
- Joined: Mon 23 Oct 2006 12:39
SOS OracleLoader
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
Best regard Gigi