[Zope] single zsql on multiple tables or multiple zsql s

[Dieter Maurer]

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