[ic] Scalable

Ron Phipps interchange-users@interchange.redhat.com
Sun Mar 17 22:47:00 2002


> -----Original Message-----
> From: interchange-users-admin@interchange.redhat.com
[mailto:interchange-
> users-admin@interchange.redhat.com] On Behalf Of
music@labyrinth.net.au
> 
> > At 04:46 PM 3/15/2002 -0600, you wrote:
> > >I read that Interchange is optimized for only around 100 items.  I
was
> > >wondering if it can scale any higher with an external database (ie
> MySQL,
> or
> > >Oracle).  Or has anyone seen corruption, or performance problems
with
> more
> > >than 100 items in a catalog despite an external database.  I hope
this
> all
> > >makes sense, thnx.
> 
> I run several catalogs that are in production and taking orders.
> One store has 140000 titles in a secondary product table running using
> mySQL
> Redhat 7.2 (256KB RAM)
> Complex searches, or even a search through 'All categories' usually
return
> a
> result list within about 2 or 3 seconds, even when hundreds of matches
are
> found!
> 
> Interchange runs a lot faster (10x?) than the portals we build using
> PHP/mySQL.
> 
> (Our only problem with IC is the dropping of encrypted card numbers in
> orders which is happening fairly frequently. The create order, encrypt
> card#, e-mail user and store owner is obviously more resource hungry
than
> complex searches. Still trying to work this one out though I am
wondering
> if
> it is a sendmail/reverse DNS problem or something similar that is
stalling
> the process.)
> 

Are you running IC 4.8.3?  Is the store experiencing the problem running
in rpc mode?  Is it the PGP that is failing with an error like "PGP
failed with status: 3072"? Does the actual sending of the email fail as
well with an error like "cannot send mail using /usr/sbin/sendmail"?   

-Ron