Re: Stored procedures Vs Non stored procedures

In <1993May27.150124.28424@evolving.com> gst@evolving.com (Giri Tirumale) writes: > I was trying to evaluate performance between ESQL/C code > executing stored procedures against code not using stored > procedures and discovered that code using stored procedures > was slower than the other. > > I was trying to get a count of the rows in a table in both the That sounds like a single statement procedure! I'd expect it to be slower, wouldn't you? > cases. The difference was even more noticable as I did the select > in a loop. I guess it depends it on how you did the looping. You don't make that clear. graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.