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