[ic] 4.9.9 slowdown in admin screens

[Stefan Hornburg]

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


-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team