Re: [Zope] single zsql on multiple tables or multiple zsql s
thanks to Dieter and Peter Bengtsson . Rajasekhar. On Sat, Dec 13, 2008 at 6:30 PM, Peter Bengtsson 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 : > > 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 > ___ 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 )
Re: [Zope] single zsql on multiple tables or multiple zsql s
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 : > 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 ___ 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 )
Re: [Zope] single zsql on multiple tables or multiple zsql s
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 ___ 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 )