-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/11/2013 12:39 PM, Jonathan Vanasco wrote:
> 1. Assuming you're using sqlalchemy, and the interface to transaction > is provided by the zope.sqlalchemy package , is there any actual > database transaction ( begin; rollback ) for non-database requests ? > ( ie, is the "transaction" entirely in pyramid, and never in > postgreqsql ? ) If your application doesn't do anything which causes sqlalchemy to register with the transaction, then you should be fine. In a ZODB app, for instance, if the view doesn't cause any persistent object to get "dirty", then the connection won't get registered with the transaction, and thus won't be affected by the commit (uninteded write-on-read can still hose you, of course). The 'transaction' module coordinates a two-phase commit with each "data manager" registered with it: the 'zope.sqlalchemy' bridge handles that part for apps that use it. The RDBMS server begins its transaction at whatever point you configure, and gets directed to commit or abort it after negotiating the TPC among all reigistered managers. > . If the above is the case, and you have multiple database connections > ( for example, a READ/WRITE or SLAVE/MASTER ) would you be able to > escape most issues of long running requests, because the database > transaction blocking would only be on the write/master and not the > read/slave ? I don't understand the problem here, if I didn't just answer it above. You would want to avoid registering the read-only connection with the transaction at all, AFAICT (in a scenario without the transaction module, you would configure that connecdtion to avoid auto-starting any transaction, and use some appropriate isolation level to insulate you). Tres. - -- =================================================================== Tres Seaver +1 540-429-0999 [email protected] Palladion Software "Excellence by Design" http://palladion.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with undefined - http://www.enigmail.net/ iEYEARECAAYFAlHfTwYACgkQ+gerLs4ltQ5KZgCgna00F+6PDcw2nAEDAOjp4vPP 2B4AoImcSBmx/mevWvzHGJwmB0VRjhVy =zjYS -----END PGP SIGNATURE----- -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/pylons-discuss. For more options, visit https://groups.google.com/groups/opt_out.
