Perfomance

Posted in 2004

Ruben Dutan — Mon, 12 Jul 2004 19:02:46 — source: IIUG Forums & Mailing Lists

Hi all We upgrade from Informix 7.31 to 9.40 in AIX and Linux. But We have problems in Informix 9.40 in updates with query. The same update, in Informix 9.40 is 10 times more slow than Informix 7.31.. Is it a bug??.. I send the updates sql and sqlexplain.out Thanks for any help Best Regards RubÃ©n IT & Busines Projects AX - APLICACIONES EXTREMAS www.aplext.com QUERY: ------ update regtl set reg[1,13] = (select ruc from tl where tl.serial = regtl.serial), reg[14,16] = (select periodo from tl where tl.serial = regtl.serial), reg[17,18] = (select secuencia from tl where tl.serial = regtl.serial), reg[19,31] = (select no_documento from tl where tl.serial = regtl.serial), reg[32,33] = (select tipo_cbte from tl where tl.serial = regtl.serial), reg[34,41] = (select fecha_e from tl where tl.serial = regtl.serial), reg[42,49] = (select fecha_r from tl where tl.serial = regtl.serial), reg[50,55] = (select serie_cbte from tl where tl.serial = regtl.serial), reg[56,62] = (select secuencia_cbte from tl where tl.serial = regtl.serial), reg[63,72] = (select autoriza_cbte from tl where tl.serial = regtl.serial), reg[73,74] = (select identificacion from tl where tl.serial = regtl.serial), reg[75,86] = (select base_imponibleg from tl where tl.serial = regtl.serial), reg[87,87] = (select codigo_por_iva from tl where tl.serial = regtl.serial), reg[88,99] = (select base_imponible_0 from tl where tl.serial = regtl.serial), reg[100,111] = (select monto_iva from tl where tl.serial = regtl.serial), reg[112,123] = (select monto_ice from tl where tl.serial = regtl.serial), reg[124,135] = (select monto_iva1 from tl where tl.serial = regtl.serial), reg[136,136] = (select codigo_ret_iva from tl where tl.serial = regtl.serial), reg[137,148] = (select monto_ret_iva from tl where tl.serial = regtl.serial), reg[149,160] = (select monto_iva2 from tl where tl.serial = regtl.serial), reg[161,161] = (select codigo_ret_iva2 from tl where tl.serial = regtl.serial), reg[162,173] = (select monto_ret_iva2 from tl where tl.serial = regtl.serial), reg[174,174] = (select tran_dev from tl where tl.serial = regtl.serial), reg[175,186] = (select cant_cbte from tl where tl.serial = regtl.serial), reg[187,198] = (select cant_nc from tl where tl.serial = regtl.serial), reg[199,210] = (select cant_nd from tl where tl.serial = regtl.serial) where serial IN (select serial from tl) Estimated Cost: 2 Estimated # of Rows Returned: 1 1) rdutan.regtl: SEQUENTIAL SCAN Filters: rdutan.regtl.serial = ANY <subquery> Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows Returned: 1 1) rdutan.tl: SEQUENTIAL SCAN Filters: rdutan.tl.serial = rdutan.regtl.serial Subquery: --------- Estimated Cost: 1 Estimated # of Rows