Slow Stored procedures
This one is odd. I had complaints of slow SP performance, so I peaked and found nothing odd in the DB, but the SP calls are difficult to read: Informix Dynamic Server Version 9.30.UC1 -- On-Line -- Up 3 days 14:48:38 -- 1195008 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 553 - cnow CR Not Wait 0 0 9.03 Last parsed SQL statement : Pß&Pß&¡¾L!Pß&Pß&¡¾L9Pß&(Pß&(¡¾LQPß&4Pß&4¡¾LiPß&@Pß&@¡¾LPß&LPß&L¡¾L(tm)Pß& XPß&X¡¾L±Pß&dPß&d¡¾LÉÿÿÿÿPß XPß I am wondering if any of you wonderful people have seen SQL statements like this? Sam Gentsch Informix Database Evangelist Voyant a Division of Polycom, Inc. direct: 303.223.6641 mobile: 303.807.2717 fax: 303.223.5292 sam.gentsch@polycom.com www.voyanttech.com Connect. Any Way You Want. This communication (including any attachments) may contain privileged or confidential information of Polycom and is intended for a specific individual. If you are not the intended recipient, you should delete this communication, including any attachments without reading or saving them in any manner, and you are hereby notified that any disclosure, copying, or distribution of this communication, or the taking of any action based on it, is strictly prohibited.
Um I also peeked. -----Original Message----- From: Gentsch, Sam Sent: Tuesday, June 29, 2004 11:13 AM To: ids@iiug.org Subject: Slow Stored procedures [3170] This one is odd. I had complaints of slow SP performance, so I peaked and found nothing odd in the DB, but the SP calls are difficult to read: Informix Dynamic Server Version 9.30.UC1 -- On-Line -- Up 3 days 14:48:38 -- 1195008 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 553 - cnow CR Not Wait 0 0 9.03 Last parsed SQL statement : P?&P?&!3/4L!P?&P?&!3/4L9P?&(P?&(!3/4LQP?&4P?&4!3/4LiP?&@P?&@!3/4L?P?&LP? &L!3/4L(tm)P?& XP?&X!3/4L?P?&dP?&d!3/4LEyyyyP? XP? I am wondering if any of you wonderful people have seen SQL statements like this? Sam Gentsch Informix Database Evangelist Voyant a Division of Polycom, Inc. direct: 303.223.6641 mobile: 303.807.2717 fax: 303.223.5292 sam.gentsch@polycom.com www.voyanttech.com Connect. Any Way You Want. This communication (including any attachments) may contain privileged or confidential information of Polycom and is intended for a specific individual. If you are not the intended recipient, you should delete this communication, including any attachments without reading or saving them in any manner, and you are hereby notified that any disclosure, copying, or distribution of this communication, or the taking of any action based on it, is strictly prohibited.
That ´s really odd, did you get the same output more than once ?. did it happen every time the procedure is running? esteban.- At 01:12 p.m. 29/06/2004 -0400, Gentsch, Sam wrote: >This one is odd. I had complaints of slow SP performance, so I peaked and >found nothing odd in the DB, but the SP calls are difficult to read: > >Informix Dynamic Server Version 9.30.UC1 -- On-Line -- Up 3 days >14:48:38 -- 1195008 Kbytes > >Sess SQL Current Iso Lock SQL ISAM F.E. >Id Stmt type Database Lvl Mode ERR ERR Vers >553 - cnow CR Not Wait 0 0 9.03 > >Last parsed SQL statement : > Pß&Pß&¡¾L!Pß&Pß&¡¾L9Pß&(Pß&(¡¾LQPß&4Pß&4¡¾LiPß&@Pß&@¡¾LPß&LPß&L¡¾L(tm)Pß& > XPß&X¡¾L±Pß&dPß&d¡¾LÉÿÿÿÿPß XPß > >I am wondering if any of you wonderful people have seen SQL statements >like this? > > > >Sam Gentsch >Informix Database Evangelist > >Voyant a Division of Polycom, Inc. >direct: 303.223.6641 mobile: 303.807.2717 >fax: 303.223.5292 >sam.gentsch@polycom.com >www.voyanttech.com > >Connect. Any Way You Want. > >This communication (including any attachments) may contain privileged >or confidential information of Polycom and is intended for a specific >individual. If you are not the intended recipient, you should delete >this communication, including any attachments without reading or >saving them in any manner, and you are hereby notified that any >disclosure, copying, or distribution of this communication, or the >taking of any action based on it, is strictly prohibited.
I did see something like it more than once...oddly enough after the Winders box sending the call was rebooted, I have not seen the mess...still slow though, but I ran the same process locally on the box and ran it a little over a second (12 times faster than the client was seeing) so I do not think it is my DB configuration. Thx -----Original Message----- From: Esteban Casuscelli [mailto:estebanc00@yahoo.com.ar] Sent: Tuesday, June 29, 2004 4:10 PM To: Gentsch, Sam; ids@iiug.org Subject: Re: Slow Stored procedures [3170] That ´s really odd, did you get the same output more than once ?. did it happen every time the procedure is running? esteban.- At 01:12 p.m. 29/06/2004 -0400, Gentsch, Sam wrote: >This one is odd. I had complaints of slow SP performance, so I peaked and >found nothing odd in the DB, but the SP calls are difficult to read: > >Informix Dynamic Server Version 9.30.UC1 -- On-Line -- Up 3 days >14:48:38 -- 1195008 Kbytes > >Sess SQL Current Iso Lock SQL ISAM F.E. >Id Stmt type Database Lvl Mode ERR ERR Vers >553 - cnow CR Not Wait 0 0 9.03 > >Last parsed SQL statement : > Pß&Pß&¡¾L!Pß&Pß&¡¾L9Pß&(Pß&(¡¾LQPß&4Pß&4¡¾LiPß&@Pß&@¡¾LPß&LPß&L¡¾L(tm)Pß& > XPß&X¡¾L±Pß&dPß&d¡¾LÉÿÿÿÿPß XPß > >I am wondering if any of you wonderful people have seen SQL statements >like this? > > > >Sam Gentsch >Informix Database Evangelist > >Voyant a Division of Polycom, Inc. >direct: 303.223.6641 mobile: 303.807.2717 >fax: 303.223.5292 >sam.gentsch@polycom.com >www.voyanttech.com > >Connect. Any Way You Want. > >This communication (including any attachments) may contain privileged >or confidential information of Polycom and is intended for a specific >individual. If you are not the intended recipient, you should delete >this communication, including any attachments without reading or >saving them in any manner, and you are hereby notified that any >disclosure, copying, or distribution of this communication, or the >taking of any action based on it, is strictly prohibited.