HPL

Hello all, I have a 2GB table and for the business i need to have three copies of this table. Though there are three copies, these copies are different at different time. Let us forget about why three copies? I did a performance analysis using HPL, DBLOAD and normal "SELECT into INSERT". This particular instance is using HDR. SO i tried DELUXE with HDR option of HPL ( 7.31.UC2 Version) as i cannot try Express mode. Here is the time frames what i found HPL -- 39 minutes DBLOAD -- 47 Minutess SELECT INSERT -- 17 Minutes In HPL, i used four pipes for loading and commit interval was every 2000 records. DBLOAD was also with the same interval. The source, target tables are fragmented across four disks using round robin. Table size is 604 bytes. No indices at the time of loading. Machine is a 6 CPU one with 2GB RAM and in HPUX 10.20 Any comments on this test. Like why HPL is taking 39 minutes which is far far away from a normal "SELECT INSERT" Thanks in advance Dhanesh

Dhanesh Kottile Veedu wrote: > > Hello all, > > I have a 2GB table and for the business i need to have three copies of this > table. Though there are three copies, these copies are different at > different time. Let us forget about why three copies? > > I did a performance analysis using HPL, DBLOAD and normal > "SELECT into INSERT". > > This particular instance is using HDR. SO i tried DELUXE with HDR option of > HPL ( 7.31.UC2 Version) as i cannot try Express mode. > > Here is the time frames what i found > > HPL -- 39 minutes > DBLOAD -- 47 Minutess > SELECT INSERT -- 17 Minutes > > In HPL, i used four pipes for loading and commit interval was every 2000 > records. > > DBLOAD was also with the same interval. > > The source, target tables are fragmented across four disks using round > robin. Table size is 604 bytes. No indices at the time of loading. > > Machine is a 6 CPU one with 2GB RAM and in HPUX 10.20 > > Any comments on this test. Like why HPL is taking 39 minutes which is far > far away from a normal "SELECT INSERT" Here's another for you: If INSERT INTO...SELECT does the job in 17 minutes then a single copy of my dbcopy.ec utility with the -F option enabled can do the job in just over 5 minutes and if you can partition the job and use row level locking you can probably run 10 copies and get this done in about 2 minutes. Give it a try. Dbcopy.ec is part of the package utils2_ak available from the IIUG Software Repository. Art S. Kagel