I just noticed that the Blogshares Price Tracker has not been updating for a couple weeks. When I looked into it, I discovered that something happened on the server so that the include files were not being found. A Dreamhost tech pointed me to their wiki page about cron jobs, where I found I had to change the path to PHP.After I got the updates going again, I rewrote a few key parts that were making the price tracker very slow. There were some SQL queries that were inefficient, so I rewrote those, and moved some data into different tables. Now the industry listing and details pages are much faster. I made the graphs a little faster, but they are still way too slow. The problem is that the graph script queries a table with over 10 million rows. I’ll try to think of some ways to speed it up.
More: continued here
This entry was posted
on Wednesday, January 23rd, 2008 at 1:02 pm
and is filed under news.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Leave a Reply
You must be logged in to post a comment.
Related Resources
Free Software Downloads and Software Reviews - Download.comFind the software you're looking for at Download.com, the most comprehensive source for free-to-try software downloads on the Web. Includes audio programs, utilities, Internet and ...
About Graphics Software - Tutorials Reviews Tips and Help for Working ... About Graphics Software is the ultimate resource for learning about graphics software for Macintosh and Windows. Guide Sue Chastain brings you informational articles, how-tos ...
HP SoftwareLearn how HP business software solutions can help maximize performance of your IT infrastructure.
Software Reviews, Download and Buy Software Online - Software.comSoftware reviews from experts and regular people. Find out what other people think about the software you want to buy. Browse a selection of reviews for antivirus software ... OS ...
Software - GNU Project - Free Software Foundation (FSF)Download distributions. If you're looking for a whole system to install, see our list of GNU/Linux distributions which are entirely free software.
Computer software - Wikipedia, the free encyclopediaComputer software is a general term used to describe a collection of computer programs, procedures and documentation that perform some tasks on a computer system. The term includes ...
Software engineering - Wikipedia, the free encyclopediaSoftware engineering is the application of a systematic, disciplined, quantifiable approach to the development, operation, and maintenance of software. It encompasses techniques ...
SoftwareOutlet.com Features A Huge Selection Of The Most Popular ... Looking for the best value in discount software? Our huge selection includes educational software, Microsoft Office, antivirus software, pc games, kids software, wholesale software ...
Welcome! - Free Software FoundationThe organization that "started it all" in free or open source software.