Max. insert rate

Hi,

        I am developing an application (in ProC) that requires a very high insert rate into a table and I am getting a rate of around 1000 tuples/sec where each tuple is 154 bytes. I am wondering whether this is the fastest possible rate. I am using a Sparc10 with the client and the server running in the same machine and the redo log files and database files are on two separate disks. The proC program uses an array of 1000 elements and following are the code fragments

        EXEC SQL CREATE TABLE comp_pamaTab (
                id       integer,
                pama_rec CHAR(150)
        )
        PCTFREE 0 PCTUSED 99 STORAGE (INITIAL 1500 K  NEXT 1500K PCTINCREASE 0);

        EXEC SQL INSERT INTO  comp_pamaTab ( id, pama_rec)
             VALUES( :val, :p_rec);

thanks for info
-Sanjoy Received on Thu Aug 04 1994 - 17:58:30 CEST