I have just optimized the performance of the Blogshares Idea Tracker's graph rendering program. The graphs are loading much faster now. The industry listing page now allows you to load the graph for any industry by clicking a button.

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.

I made some improvements to the graphing program, it now displays the change percentage.

I have created a new program that tracks price flucuations in the BlogShares fantasy market. The basic functions are working, and more sophisticated functions are planned. The graphs are created in real time by PHP.

http://www.sproutworks.com/blogsharesideas.php

Hi,
http://www.sproutworks.com/blogsharesideas.php currently shows only a limited ideas. I am wondering whether you are capturing only the ideas available in market.

And similarly with Portfolio analysis, how do we go to the next page since again a limited number is shown in the first(??) page.

Thanks