---------------------------- Original Message ---------------------------- Subject: Re: [ic] SECURE_SERVER options From: "Mike Heins" <suppressed> Date: Wed, May 11, 2005 11:38 am To: suppressed -------------------------------------------------------------------------- Quoting Daniel Davenport (suppressed): > > Second question, > > i assume that to use MYSQL_TRANSACTIONS=1 the mysql DB must use INNODB tables? how has the luck been with INNODB and interchange performace as well as how much does interchange suport transactions? > > I don't use innodb, so i wouldn't be too helpful in that regard. 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. -- Mike Heins Perusion -- Expert Interchange Consulting http://www.perusion.com/ phone +1.765.647.1295 tollfree 800-949-1889 <suppressed> Nature, to be commanded, must be obeyed. -- Francis Bacon _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users --------------------------------------------- For free email or hosting solutions look to http://www.michiganlivestock.com/mlds Is it recomened to use transactions and innodb with interchange though? I dont see why it wouldn't be. --------------------------------------------- For free email or hosting solutions look to http://www.michiganlivestock.com/mlds _______________________________________________ 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.