[ic] 4.9.9 slowdown in admin screens

Ed LaFrance edl at newmediaems.com
Tue Nov 18 12:51:01 EST 2003


At 09:06 PM 11/18/2003 +0100, you wrote:
>On Tue, 18 Nov 2003 10:38:41 -0800
>Ed LaFrance <edl at newmediaems.com> wrote:
>
> > At 11:28 AM 11/18/2003 -0500, you wrote:
> > > > Which database are you using? Which operating system? Which
> > > > Perl version?
> > >
> > >Perl 5.6.1 no threads
> > >Ic 4.9.9
> > >Redhat 9.0
> > >mysql  Ver 12.22 Distrib 4.0.16
> > >
> > >4.9.8, same setup (other than 4.9.9 upgrade) we had no slowness issues
> > >in the backend.
> >
> > I would suggest turning on mysql logging and then seeing what kind of
> > queries are being received from IC when you are trying to navigate the
> > backend (if you see alot of 'select * from table' without filtering
> > criteria, that is very likely to bog down the Admin when dealing with 
> large
> > tables). Also, run top and observe it when trying these operations. These
> > would be my first steps to trying to identify the bottleneck.
>
>The UI uses the mv_metadata and access table, which aren't SQL databases
>in the standard foundation setup.
>
>Bye
>         Racke

Right - but his complaint was about slowness when viewing the Item list, 
Customer list, Orders list, etc - these can be very slow when those tables 
grow quite large and an SQL database is being employed.


- Ed


===============================================================
New Media E.M.S.              Technology Solutions for Business
11630 Fair Oaks Blvd., #250   eCommerce | Consulting | Hosting
Fair Oaks, CA  95628          edl at newmediaems.com
(916) 961-0446                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (916) 961-0447 Fax
=============================================================== 



More information about the interchange-users mailing list