18 Nov
2003
18 Nov
'03
10:58 a.m.
Hi, I am looking for a general advice for a caching-strategy for zsql-methods: I have to execute 2 sql-queries in sequence: Query one (Q1) limits the table-data to a certain amount. This query does not change often and should be cached. Query two (Q2) selects a part of the results of query one. Q2 is dynamic. What is the best strategy (performance, data-transfer) to cache Q1in ZOPE if I can not use views or stored procedures on the db-side? -- thanks for any hint, Sebastian K. (Please answer to my mail address directly as I am currently not subscribed to this list, thanks)