Jorge Vargas wrote: > On 10/20/06, Mark Ramm <[EMAIL PROTECTED]> wrote: > > > > > The site, as far as they've decided so far, will be transaction > > > oriented and contain financial data. They are expecting 1000 > > > concurrent users, possibly more, over time. > > > > tg-admin sql create will create standard MySQL tables by default, so > > no transaction support there. If you want to use "sql create" and > > you want transaction support I highly recomend postgres. > > what about setting the engine to InnoDB, will it still don't do that? > I just realice I haven't done much with tg/so/mysql
InnoDB has transaction support and honors foreign key constraints. My understanding is that all you need to do differently to use it is get the sql code, change the table type, and build the tables manually from that. That said, Postgres does much better with data integrity. You may want to check out the Wikipedia entry on MySQL criticisms[1] to make sure you are aware of all the issues involved in using MySQL. -Adam [1] http://en.wikipedia.org/wiki/Mysql#Criticisms_of_MySQL > > > > > --Mark Ramm > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears -~----------~----~----~----~------~----~------~--~---
