[Zope] RV: About knowledge product....

[Andreas Kostyrka]

On Mon, 20 Sep 1999, Francisco Sam Castillo wrote:

> databaseand
>  for example Mysql
>  that is not, when use together you do get the benefits of transactional
>  Databases because zope
>  will rollback if anything goes wrong as a transactional database should do,
Well, that depends. If it works, then the mysqlDA does some pretty extra
work. Additionally, it's not just transactions that are missing from
mysql. Isolation normally comes with transactions, something that is very
difficult to provide afterwards.

Additionally, you cannot implement transactions completely without support
for transactions in the underlying database: Even if the mysqlda would
defer insert/update statements till commit time (a thing that might be not
feasible, because you could have a string of sql like insert/select
the new data in a transaction), it would not be ACID if the host crashes
during commit time.

Andreas
--
Andreas Kostyrka                     | andreas@mtg.co.at
phone: +43/1/7070750                 | phone: +43/676/4091256   
MTG Handelsges.m.b.H.                | fax:   +43/1/7065299
Raiffeisenstr. 16/9                  | 2320 Zwoelfaxing AUSTRIA