RE: Slow filters in HPL

Posted in 2005

Savio Pinto (s) — Mon, 14 Mar 2005 12:06:25 -0600 — source: Usenet: comp.databases.informix

how many rows are in the table that you are applying the filter? is your query doing sequential scan on the table ? or you may try tweaking the plconfig file -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Andy Kent Sent: Saturday, March 12, 2005 12:18 PM To: informix-list@iiug.org Subject: Slow filters in HPL Is it just me or can HPL be incredibly slow at evaluating complex filters? I have two unload jobs on the same table, one of the complete table and one which eliminates any of 100 or so row types older than a certain date. The filtered one goes orders of magnitude more slowly through the table. I'd put the criteria in a table and join to that but I can't get our version to accept joins (at least not through ipload). Is there something I should tweak or is HPL just simply bad at logic processing? Andy Kent sending to informix-list