Quoting Jon Jensen (suppressed): > 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. The only tables that Interchange lays out as InnoDB is those three, if left to itself. The rest are whatever the database default is -- I think MyISAM. -- Mike Heins Perusion -- Expert Interchange Consulting http://www.perusion.com/ phone +1.765.647.1295 tollfree 800-949-1889 <suppressed> Some people have twenty years of experience, some people have one year of experience twenty times over. -- Anonymous _______________________________________________ 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.