Web performance

Working on a home project? Post it here.
Post Reply
eisensms
Posts: 6
Joined: Thu Mar 10, 2011 3:31 am

Web performance

Post by eisensms » Tue Dec 13, 2011 10:08 am

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.
brk
Posts: 1
Joined: Mon Feb 28, 2011 10:13 pm

Re: Web performance

Post by brk » Thu Dec 22, 2011 4:55 pm

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.
eisensms
Posts: 6
Joined: Thu Mar 10, 2011 3:31 am

Re: Web performance

Post by eisensms » Thu Dec 22, 2011 9:05 pm

I figured it out myself. I just deleted 99% of the data in the database (2 years worth),
and performance got snappy again! Thanks.
ben
Site Admin
Posts: 4254
Joined: Fri Jun 04, 2010 9:39 am

Re: Web performance

Post by ben » Fri Dec 23, 2011 2:07 pm

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.
Ben
Brultech Research Inc.
E: ben(at)brultech.com
Post Reply