Am 19.02.2009, 01:15 Uhr, schrieb Jaroslav Lukesh :
> Hi,
> we have moved from complicated SQL query into stored procedure with few
> temporary tables with about 100x gain. Without changing any zope code,
> except calling SQL query. SQL query cost about 40sec (SQL server time),
> now with s
Am 18.02.2009, 21:36 Uhr, schrieb Allen Schmidt Sr.
:
> I understand. Thanks.
> Did not realize there was a new version of the python/zmysqlda
> available. Thanks for that info. Would really like to use the mx
> connectors but at this point if I can use an updated free one and it
> works,
I understand. Thanks.
Did not realize there was a new version of the python/zmysqlda
available. Thanks for that info. Would really like to use the mx
connectors but at this point if I can use an updated free one and it
works, then I need to do that.
And no, all our stuff is in the ZODB as ZSQL
Am 18.02.2009, 20:24 Uhr, schrieb Allen Schmidt Sr.
:
> Hey Charlie,
> What timing. I am having my server guys drop the trial egenix zope da in
> place as I write this. Seeing too many errors and oddities with the
> ancient MySQLDA we use now. Planning on converting all our mysql
> connect
Thanks for your help!
Rémy
On Wed, Feb 18, 2009 at 3:53 AM, Charlie Clark wrote:
> Am 18.02.2009, 00:58 Uhr, schrieb :
>
> > Using external methods will be more work for the zope writer.
> > I don't know enough to comment seriously on security issues,
> > but I think that using procedures, like
Am 18.02.2009, 00:58 Uhr, schrieb :
> Using external methods will be more work for the zope writer.
> I don't know enough to comment seriously on security issues,
> but I think that using procedures, like using bind variables, will
> make SQL Injection much harder.
The mxODBC Zope DA makes the e
er
02/17/2009 06:44 PM
To
jpe...@ykksnap-america.com
cc
Remy Pinsonnault , zope-db@zope.org
Subject
Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods
Quoting jpe...@ykksnap-america.com :
> Yes, with a stored procedure the DB does not have to reparse and
> prepare a new plan f
Quoting jpe...@ykksnap-america.com :
> Yes, with a stored procedure the DB does not have to reparse and
> prepare a new plan for every query. This can be a major win. Esp.
> on Oracle.
Does ZSQL allow the use of bind variables? If so and the database has
a correctly sized query cache, there sho
Yes, with a stored procedure the DB does not have to reparse and
prepare a new plan for every query. This can be a major win. Esp.
on Oracle.
Remy Pinsonnault
Sent by: zope-boun...@zope.org
02/17/2009 06:37 PM
To
zope-db@zope.org, z...@zope.org
cc
Subject
[Zope] Stored Procedures Versus
