[Zope] Double and Triple Posts

[Andy Yates]

> > When a user comes to the main page on my site 100+ values are loaded
> > from a MySQL db and are stored in the SESSION object.  These values
are
> > used to customize everything from text to images on the site.  So,
there
> > are tons of reads and writes to the SESSION object going on all the
> > time.
> >
> > The only problem I've seen is when I am sending email (multiple
emails),
> > processing credit cards (double,triple billing), and inserts into
the db
> > (duplicate inserts, key violations).
> 
> What MySQL table type are you using? If you are using MyISAM (the
> standard type) -- and it sounds like you are -- you are basically
> doomed. However, if you convert your database to use InnoDB tables,
> which support transactions, you should be fine. What versions of
> MySQLdb and ZMySQLDA are you using, and did you explicitly disable
> transaction support in ZMySQLDA?

I guess I'm doomed. ;-) I use MyISAM tables mainly because that was all
that was available way back when the database was created.  That was
when MySQL was not concerned with and was even proud that they were not
SQL compliant.  Now years and 100Gig+ later nobody is brave enough to
change the table types.

Looks like I should at least change the table type on tables that Zope
write to.


> --
> Computer interfaces should never be made of meat.
> 
> Using GMail? Setting Reply-to address to <> disables this annoying
feature.
> 
> You are in a maze of twisty little passages all alike.
> To go north, press 2. To go west, press 4.
> To go east, press 6. To go south, press 8.
> If you need assistance, press 0 and a little dwarf
> will assist you.
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )