Re: Find time consuming SQL statements

Stefan, At my site it has the same effect as the TOPS program. TOPS is always on top. Most times longsql find's only him self ! Can you surpress the cbl_stmt him self from the query ? and surpress the "No rows found." message ? rgds /Arthur ----- Original Message ----- From: Stefan Weideneder <stefan@weideneder.de> To: <informix-list@iiug.org> Sent: Wednesday, July 30, 2003 2:10 PM Subject: Find time consuming SQL statements > --nextPart1379302.Md0IASE3tp > Content-Type: text/plain; charset=iso-8859-15 > Content-Transfer-Encoding: 8Bit > > Hi all, > > interested in a script which tries > to find SQL-statements that do not > send a response to the client > in less than 4 seconds ? > > Hope it will work ... > > BR > > Stefan > sending to informix-list