Page 1 of 1
Import Data speed too slow
Posted: Wed 07 Dec 2016 05:11
by joongtang
Hello, I'm using dbForge for Oracle 3.9.22
I connect by Direct mode and Import Data
then data import speed too slow.
but I connect by TNS then data import speed normal
but not fast compared to other db tools.
is this bug??
I look forward to your reply.
ps. oracle db version is 12c Enterprise Edition Release 12.1.0.2.0.
Re: Import Data speed too slow
Posted: Wed 07 Dec 2016 10:59
by alexa
Could you please provide us the CREATE definition of the table you were performing import into (if applicable)?
Please also let us know what's the amount of the records to import and what's the imported file type?
You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom
Re: Import Data speed too slow
Posted: Thu 08 Dec 2016 02:10
by joongtang
Thanks reply, but not specific table, all table.
amount of the records is about 7000 and import file type is xlsx.
import speed is 3 records / 1s.
It is too slow~
Thank you.
Code: Select all
CREATE TABLE SCS_M_LINK_DETAIL (
LINK_ID VARCHAR2(10 BYTE),
NUM NUMBER(4, 0),
GROUP_NUM NUMBER(3, 0),
POINT_LAT VARCHAR2(20 BYTE),
POINT_LNG VARCHAR2(20 BYTE),
CONSTRAINT SCS_M_LINK_DETAIL_PK PRIMARY KEY (LINK_ID, NUM, GROUP_NUM) USING INDEX TABLESPACE US_SCS_MST_IDX PCTFREE 2 STORAGE (INITIAL 64 K
NEXT 1 M
MAXEXTENTS UNLIMITED)
)
TABLESPACE US_SCS_MST_DAT
STORAGE (INITIAL 64 K
NEXT 1 M
MAXEXTENTS UNLIMITED)
LOGGING;
Re: Import Data speed too slow
Posted: Thu 08 Dec 2016 11:43
by .jp
Hi,
We've reproduced the problem and will include the fix in the next maintenance build.
Best Regards.
Re: Import Data speed too slow
Posted: Fri 09 Dec 2016 02:00
by joongtang
Thanks ^^