[ic] SECURE_SERVER options

Mike Heins mike at perusion.com
Wed May 11 16:16:15 EDT 2005


Quoting Jon Jensen (jon at endpoint.com):
> 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 <mike at perusion.com>

Some people have twenty years of experience, some people have
one year of experience twenty times over. -- Anonymous


More information about the interchange-users mailing list