Skip to Content
0
Former Member
Sep 24, 2014 at 02:50 PM

slow insert into IQ 15.4 from ASE 15.5

122 Views

In IQ we have a table with 3 columns (searched_column char(7),id int, rr varchar(5)), let call the tabel IQ_tbl.

In our ASE database we have a proxy table to the IQ table with the same definition called prx_IQ_tbl.

The following insert statment takes 1 minute to acheive:

set rowcount 5000

insert into prx_IQ_tbl select adp_num, 111, 'dev' from adp_info

Indeed after 1 minute 5000 records are inserted into the IQ table

Is there a way to increase the speed?

CIS info of our ase server is as follows:

Parameter Name Default Memory Used Config Value Run Value Unit Type

---------------------------------------- ------------ ------------ -------------------------- -------------- ----------- -------------

1 cis bulk insert array size 50 0 500 500 rows dynamic

2 cis bulk insert batch size 0 0 0 0 rows dynamic

3 cis connect timeout 0 0 0 0 seconds dynamic

4 cis cursor rows 50 0 50 50 number dynamic

5 cis idle connection timeout 0 0 0 0 seconds dynamic

6 cis packet size 512 0 2048 2048 bytes dynamic

7 cis rpc handling 0 0 0 0 switch dynamic

8 enable cis 1 0 1 1 switch static

9 max cis remote connections 0 5346 0 0 number dynamic