How to insert data fast
From: Takaoki Sekiguchi <takaoki_at_cow.melco.co.jp>
Date: Thu, 14 Jul 1994 18:26:31 GMT
Message-ID: <TAKAOKI.94Jul14132631_at_visar.cow.melco.co.jp>
Date: Thu, 14 Jul 1994 18:26:31 GMT
Message-ID: <TAKAOKI.94Jul14132631_at_visar.cow.melco.co.jp>
I am going to insert 2GB data into oracle database. But it took about 1 hour to insert 40MB data.!!
The situation is as follows.
1 Data is created by program and sent to oracle by oci functions.
2 Data is stored in array(size 100) and sent by 'oexn' function.
3 Commit is made for each oexn.
4
4 It is impossible to use The direct path for SQL*Loader ,
because table are made on hashed cluster. It is invalid to use the direct path SQLload for hashed cluster. 5 SQL*Loader using normal path is slower than the oci program.
I have some questions.
Please send mail to takaoki_at_ok.cow.melco.co.jp
,if it's not inconvinient for you.
and to What values do I set those parameters? Q3,
Thanks in advance.
--Received on Thu Jul 14 1994 - 20:26:31 CEST
**************************************************
三菱電機(株) 情報システム製作所 高性能サーバ開発部 開発第3グループ 関口 孝興 E-mail: takaoki_at_ok.cow.melco.co.jp 〒251 神奈川県鎌倉市上町屋325番地 TEL 0467-43-8301 FAX 0467-43-8272 MIND 7-421-8548
**************************************************