Work, work, work
I think the database is finally correct. phpMyAdmin is such a pain when it comes to very large databases. I suppose it’s not really the applications fault but the server settings for mysql. The default timeout for “importing” an SQL dump is 5 minutes and when one has a few hundred thousand lines of SQL commands to run it takes a while.
I think I’ve lost a few comments in the past few days but will try to get those put back in the database real soon.
Also, I’ve tried to speed up the loading of the main page by moving the Bloglines links to an early morning cron job that runs the following code and redirects it to a static file that gets read with each page request:
#!/usr/bin/php
$page = ‘’;
$fh = fopen(’http://rpc.bloglines.com/blogroll?
html=1&id=EvangelicalAggregator’, ‘r’)
or die($php_errormsg);
while (! feof($fh)) {
$page .= fread($fh, 8192);
}
fclose($fh);
// Let’s filter the Bloglines feed so that it
// kind of meets XHTML 1.0 standards
$page = preg_replace(’/&/’,'&’,$page);
print $page . “\n”;
It looks like there some word wrap going on with the fopen statement.
The next thing I’m going to do is save all those badges to the right locally so they load faster. I’m also going to to convert the TTLB Ecosystem thing to something other than javascript and see if that makes it load faster. I think that’s the next biggest bottleneck.
If you figure out a way to get the TTLB blogroll to load faster, please let me know. I’m having the same problem!
Comment by theophile — November 17, 2005 @ 1:34 pm