On Wed, 11 May 2005, Mike Heins wrote:
For reference, though, BDB tables can also do transactions. I haven't tested them performance-wise; i'm just telling what i know. :)For most sites, the performance doesn't matter, since the only tables that are put in transaction mode are userdb, orderline, and transactions at order time. Even on a busy site that takes hundreds of orders an hour, the overall impact is small.
My understanding is that InnoDB and BDB tables are slower than MyISAM tables for every operation, including reads, regardless of whether the current connection is in a transaction or not. I haven't seen them to be noticeably slower, but I normally use PostgreSQL on larger-scale sites and so don't have data myself to say one way or the other.
Jon _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.