Use the Z SQL Method cache if you can. The important difference is that the z sql method cache is for all people whereas the REQUEST is just for one person. Generic SQL: SELECT COUNT(*) FROM documents; Personal SQL: SELECT COUNT(*) FROM documents WHERE uid=<dtml-sqlvar your_username type="string">
On 6/23/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > > I am developing an application that is a front end to an RDBMS. > Sometimes, when loading a page, several scripts get called that all > require the same information from the database. It would obviously be > costly for each script to call the same ZSQL method. My method for > avioiding this senario is... > > Get the scripts to call another script that is a wrapper to the ZSQL > method. This wrapper script returns context.REQUEST[value_name] if it > exists or, if it does not exist, executes the ZSQL method, stuffs the > result into REQUEST[value_name] and then returns it. > > I am not convinced that this is the right way of dealing with this > situation however. Is there a better way? > > Thanks, > > Calisp > _______________________________________________ > 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 )