Import Data speed too slow

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
joongtang
Posts: 12
Joined: Wed 07 Dec 2016 04:46

Import Data speed too slow

Post by joongtang » Wed 07 Dec 2016 05:11

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.

alexa
Devart Team
Posts: 2430
Joined: Fri 24 Jun 2011 14:17

Re: Import Data speed too slow

Post by alexa » Wed 07 Dec 2016 10:59

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

joongtang
Posts: 12
Joined: Wed 07 Dec 2016 04:46

Re: Import Data speed too slow

Post by joongtang » Thu 08 Dec 2016 02:10

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;

.jp
Devart Team
Posts: 307
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Import Data speed too slow

Post by .jp » Thu 08 Dec 2016 11:43

Hi,

We've reproduced the problem and will include the fix in the next maintenance build.

Best Regards.

joongtang
Posts: 12
Joined: Wed 07 Dec 2016 04:46

Re: Import Data speed too slow

Post by joongtang » Fri 09 Dec 2016 02:00

Thanks ^^

Post Reply