Page 1 of 1

Web performance

Posted: Tue Dec 13, 2011 10:08 am
by eisensms
Does anyone have any tips for giving the web interface snappier performance (i.e. response time)? Thanks! /spe

http://ecm1240.plotit.com

Server has AMD Processor Quad-core AMD phenom II x4 965 processor, 64 bit Windows Server 2008 O/S, 8 gigs of RAM, and a Terabyte of free diskspace. I am thinking about putting the
database on a RAM disk.

Re: Web performance

Posted: Thu Dec 22, 2011 4:55 pm
by brk
Looks to me like you need to optimize the underlying database. Without any details on what your running, it is an impossible question to answer.

Re: Web performance

Posted: Thu Dec 22, 2011 9:05 pm
by eisensms
I figured it out myself. I just deleted 99% of the data in the database (2 years worth),
and performance got snappy again! Thanks.

Re: Web performance

Posted: Fri Dec 23, 2011 2:07 pm
by ben
eisensms wrote:I figured it out myself. I just deleted 99% of the data in the database (2 years worth),
and performance got snappy again! Thanks.
You could backup/recreate your database every 6 months or so, also enable minute compressing in the database menu.