Re: MySQL & prepared sql statements?

2002-11-24 Thread Stas Bekman
David Wheeler wrote: On Sunday, November 24, 2002, at 01:08 PM, Bas A.Schulte wrote: I'm wondering if I would gain (some) performance by preparing my sql statements once during ChildInit when using MySQL? Does it cache execution plans for sql statements? I know it makes a big difference on O

Re: MySQL & prepared sql statements?

2002-11-24 Thread David Wheeler
On Sunday, November 24, 2002, at 01:08 PM, Bas A.Schulte wrote: I'm wondering if I would gain (some) performance by preparing my sql statements once during ChildInit when using MySQL? Does it cache execution plans for sql statements? I know it makes a big difference on Oracle but I'm not sure

MySQL & prepared sql statements?

2002-11-24 Thread Bas A . Schulte
Hi, I'm wondering if I would gain (some) performance by preparing my sql statements once during ChildInit when using MySQL? Does it cache execution plans for sql statements? I know it makes a big difference on Oracle but I'm not sure what MySQL is like in this respect. Regards, Bas.