single zsql on multiple tables or multiple zsql s
Hi All, In my project iam using zsqls. Now i want to improve performance of project.So i thought to reduce number of zsqls,expecting it may improve performance. using one zsql to fetch values from different tables ,can increase performance ?(instead of using multiple zsqls on multiple tables). Is there anyother ways to improve performance in using zsql.please suggest me if any. Thanks in advance, Raj.
indrajit926 indra wrote at 2008-12-12 18:21 +0530:
Now i want to improve performance of project.So i thought to reduce number of zsqls,expecting it may improve performance.
The runtime performance is only minimally affected (ZSQL methods are small objects). The structure of your ZSQL methods may impact development performance: a small set of well named objects is better to grasp than a huge set with badly named objects. With ZSQL methods, you must also be very careful with SQL injection attacks. The more parameters your methods have, the more risky that can get -- especially when the parameters come directly from the request as ZSQL methods suggest (note that the request content is inherently unsafe). -- Dieter
Assuming you're developing your product on the filesystem and not inside the ZMI you can use this: http://www.fry-it.com/oss/ZSQL which has some profiling options. 2008/12/12 indrajit926 indra <indrajit926@gmail.com>:
Hi All,
In my project iam using zsqls.
Now i want to improve performance of project.So i thought to reduce number of zsqls,expecting it may improve performance.
using one zsql to fetch values from different tables ,can increase performance ?(instead of using multiple zsqls on multiple tables).
Is there anyother ways to improve performance in using zsql.please suggest me if any.
Thanks in advance, Raj.
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
-- Peter Bengtsson, work www.fry-it.com home www.peterbe.com hobby www.issuetrackerproduct.com
thanks to Dieter and Peter Bengtsson . Rajasekhar. On Sat, Dec 13, 2008 at 6:30 PM, Peter Bengtsson <peterbe@gmail.com> wrote:
Assuming you're developing your product on the filesystem and not inside the ZMI you can use this: http://www.fry-it.com/oss/ZSQL which has some profiling options.
2008/12/12 indrajit926 indra <indrajit926@gmail.com>:
Hi All,
In my project iam using zsqls.
Now i want to improve performance of project.So i thought to reduce number of zsqls,expecting it may improve performance.
using one zsql to fetch values from different tables ,can increase performance ?(instead of using multiple zsqls on multiple tables).
Is there anyother ways to improve performance in using zsql.please suggest me if any.
Thanks in advance, Raj.
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
-- Peter Bengtsson, work www.fry-it.com home www.peterbe.com hobby www.issuetrackerproduct.com
participants (3)
-
Dieter Maurer -
indrajit926 indra -
Peter Bengtsson