[Zope-DB] Relational Databases in Zope 2 and Zope 3
scot.roberts at five.tv
Tue Jun 29 11:17:13 EDT 2004
Tres Seaver wrote:
> The dilemma here is similar to the classic one between OLAP and OLTP:
> arbitrarily flexible queries are death to transactional throughput.
> If your application *needs* this flexibility, then you *can't* take
> advantage of prepared queries anyway, as there is no "canonical" version
> of the query to prepare. There are is *huge* space of applications,
> however, which *could* benefit from prepared queries; for them the
> price of DTML's flexibility is both painful and unneccessary.
Which means that there's a need for both ZSQL Methods as they stand now
(perhaps with the dtml- bit removed from the tags) for those of us who
value flexibility over raw throughput and some other method for writing
prepared queries. Although have to wonder why I wouldn't just used a
stored procedure on the db server instead of having a prepared query in
Zope, because if I was that concerned with performance that's what I do.
This e-mail may contain information that is privileged, confidential or otherwise protected from disclosure. It must not be used by or its contents copied or disclosed to persons other than the intended recipient. Any liability arising from any third party acting or refraining from acting on any information contained in this e-mail is excluded. If you have received this e-mail in error please notify the sender immediately and delete it and any copies from your computer and network. This e-mail has been checked for viruses but it is the responsibility of the recipient to ensure that the opening use or onward transmission of the e-mail and any attachments will not adversely affect its systems or data and no responsibility is accepted by Five in this regard.
More information about the Zope-DB