Re: Which one faster?
Yes but at this point it places a lock on sysprocplan. It's much better to update the stats for your procedures as part of your std table update stats. Paul Watson WF Software Ltd Tel +44 1436 674729 Fax +44 1436 678729 www.wfsoftware.co.uk >>> Richard Auslander <rich@airflash.com> 07/26/99 01:34am >>> Paul - I think I read in the Informix docs that it re-optimizes stored procedures before running them IF it detects that one of the underlying tables or views has changed. Paul Wilson wrote: > But as database changes.. remember to update the statistics for the stored > procedure... otherwise optimizer plan will be out of date! > > Irineu Rocha <irineu@sisgraph.com.br> wrote in message > news:7naevo$s11$1@news.xmission.com... > > > > Stored procedures are faster than other ones. > > > > SISGRAPH > > Irineu Tachinardi Rocha > > AIM Group - Sisgraph (Intergraph Brazil) > > System Analyst > > Email: irineu@sisgraph.com.br > > Phone: 55-11-8892058 Fax: 55-11-8877763 > > http://www.sisgraph.com.br > > > > > > > ---------- > > > From: i.sokolsky@geac.com[SMTP:i.sokolsky@geac.com] > > > Reply To: i.sokolsky@geac.com > > > Sent: Friday, July 23, 1999 2:31 PM > > > To: informix-list@iiug.org > > > Subject: Which one faster? > > > > > > Hi > > > > > > 1.Is there a difference in the speed between Stored Procedure and C > > > executable that execute same sql statments? > > > > > > 2.What will give faster result Client (VB) ,which executes sql code, > > > or if a client will execute a stored procedure on a server? > > > > > > Regards > > > > > > > > > Igor > > > -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************
Paul watson wrote: > > Yes but at this point it places a lock on sysprocplan. It's much better to update the stats for your procedures as part of your std table update stats. Also the engine does not always detect that a particular procedure needs to be recompiled so it is always best to UPDATE STATISTICS on all procedures that touch a table you are altering of even after running UPDATE STATISTICS on the tables. Since this is very fast it is usually best to just UPDATE STATISTICS on all procedures so you can feel confident you did not miss any. Art S. Kagel > Paul Watson > WF Software Ltd > Tel +44 1436 674729 > Fax +44 1436 678729 > www.wfsoftware.co.uk > > >>> Richard Auslander <rich@airflash.com> 07/26/99 01:34am >>> > Paul - I think I read in the Informix docs that it re-optimizes stored > procedures before running them IF it detects that one of the underlying tables > or views has changed. > > Paul Wilson wrote: > > > But as database changes.. remember to update the statistics for the stored > > procedure... otherwise optimizer plan will be out of date! > > > > Irineu Rocha <irineu@sisgraph.com.br> wrote in message > > news:7naevo$s11$1@news.xmission.com... > > > > > > Stored procedures are faster than other ones. > > > > > > SISGRAPH > > > Irineu Tachinardi Rocha > > > AIM Group - Sisgraph (Intergraph Brazil) > > > System Analyst > > > Email: irineu@sisgraph.com.br > > > Phone: 55-11-8892058 Fax: 55-11-8877763 > > > http://www.sisgraph.com.br > > > > > > > > > > ---------- > > > > From: i.sokolsky@geac.com[SMTP:i.sokolsky@geac.com] > > > > Reply To: i.sokolsky@geac.com > > > > Sent: Friday, July 23, 1999 2:31 PM > > > > To: informix-list@iiug.org > > > > Subject: Which one faster? > > > > > > > > Hi > > > > > > > > 1.Is there a difference in the speed between Stored Procedure and C > > > > executable that execute same sql statments? > > > > > > > > 2.What will give faster result Client (VB) ,which executes sql code, > > > > or if a client will execute a stored procedure on a server? > > > > > > > > Regards > > > > > > > > > > > > Igor > > > > > > -- > Richard C. Auslander > Database Manager > > AirFlash, Inc. > 1733 Woodside Rd., Suite #110 > Redwood City, CA 94061 > (650) 556-7928 > > www.airflash.com > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses. > > www.mimesweeper.com > **********************************************************************