GrabPERF: Reduced Raw Data Storage Time

In: GrabPERF

16 Aug 2005

In the GrabPERF system, all of the detail charts are built off of the raw data table. Now, for some insane reason, I was storing 50 days of raw data. The furthest back that any of the configured raw data graphs goes is 7 days.

I reset the data purge script to drop data older than 10 days. This should speed up queries and graph displays.

If certain users would like to keep data for longer, I could modify the drop procedure for custom data storage lengths. Just let me know if you require raw data from longer periods and I will begin development on this.


Technorati: , , , , ,

IceRocket: , , , , ,

Spread the Love:
  • Facebook
  • Twitter
  • Ping.fm
  • Digg
  • StumbleUpon
  • LinkedIn
  • Reddit
  • Slashdot
  • Netvouz
  • Identi.ca
  • Technorati
  • del.icio.us
  • email

Related Posts

blog comments powered by Disqus

About this blog

Stephen Pierzchala is one of a 10-year veteran of the Web performance field who also writes on topics that interest his non-linear world-view.

Contact

stephen@pierzchala.com

+1 (508) 410-3865