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
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 ...
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 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 ...
JourneyEd.com - Academic Software Discounts!North America's leading seller of software to students, faculty and schools at academic discounts. Save up to 75% off!!
Discount Software at Your One Stop Software Shop | SoftwareMedia.com Buy discount software online for PC or Mac. Cheap computer software such as OEM, software licensing, Microsoft, Adobe, Symantec. Discounted software, free shipping & returns!
Calyx Point Mortgage Loan Origination and Processing Software & Calyx ... Calyx Point and WebCaster provide mortgage origination, automation solutions for mortgage businesses.
HP SoftwareLearn how HP business software solutions can help maximize performance of your IT infrastructure.
Welcome! - Free Software FoundationThe organization that "started it all" in free or open source software.
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.