[ic] 4.9.9 slowdown in admin screens
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
> > 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.
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.
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