Hi!
Your site being slow can have multiple reasons. I think last time I checked it boiled down to your mysql server being pretty, pretty slow. To get a benchmark of your server, you can do this:
1. Open your file include/db/mysql.inc.php.
2. Search for the function serendipity_db_query
3. Find this code:
Code: Select all
if ($expectError) {
$c = @mysql_query($sql, $serendipity['dbConn']);
} else {
$c = mysql_query($sql, $serendipity['dbConn']);
}
replace it with this:
Code: Select all
$start = microtime_float();
if ($expectError) {
$c = @mysql_query($sql, $serendipity['dbConn']);
} else {
$c = mysql_query($sql, $serendipity['dbConn']);
}
$end = microtime_float();
$fp = fopen('mysql.log', 'a');
fwrite($fp, $_SERVER['REQUEST_URI'] . " - " . $_SERVER['REMOTE_ADDR'] . " - " . round($end-$start, 4) - ": " . str_replace("\n", "", $sql) . "\n");
fclose($fp);
4. Open the main page of your blog.
5. Now a file "mysql.log" should be created in your serendipity dirrectory. It contains every SQL query. Add up all times for your request and see if some queries stand out. If the total time spent for queries does not add up to the total time a request takes, it's not MySQL making the trouble.
In that case you'd need to report me which event and sidebar plugins you have installed. It can be that specific plugins are slow.
Regarding paypal: Have a look at my signature.
Regards,
Garvin
But then again, I also have a paypal account... *eg*