User and developer community
https://board.s9y.org/
T wrote:After I added quite a lot of static pages, I began to notice a much slower server performance; static pages now sometimes take half a minute to load. Can I counter this by changing anything Serendipity-related or do I just have a crappy server?
Best regards,
Thanks for the reply. It's just a few hundred static pages. Visitors have been basically just myself, as the site is not in use yet. I have installed just some basic plugins, and the Wiki links plugin (as to interlink the SP's)... So, crappy server-problem?garvinhicking wrote:Basically the performance should only decrease with a few THOUSAND staticpages.
Could it be you installed other serendipity plugins? That can be more of a performance reason...or maybe you now have more visitors that lead to more server load?
Sidebar: I have removed all unneeded plugins; now there is nothing SP-related in the sidebar anymore.garvinhicking wrote:Please tell more about your site, the plugins you're using (sidebar and event).
Overview and blog entries about the same, and quite fast. A single static page: takes everywhere between 5 and 15 seconds, so quite slow. SP overviews take even longer.garvinhicking wrote:Okay. Is the time it takes to open your blog entry overview roughly the same time it takes to display a single blog entry? And is this time roughly the same like when viewing a single static page?
If the performance differes, where is it slowest?
Code: Select all
static $benchmark = false;
Code: Select all
static $benchmark = true;
Code: Select all
CREATE TABLE `BLOGLOG` (
`request` varchar(255) NOT NULL default '',
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`sql` text NOT NULL,
`exec_time` varchar(50) NOT NULL default '0',
`ip` varchar(20) NOT NULL default ''
);
CREATE TABLE `BLOGLOG_TOTAL` (
`sql` text NOT NULL,
`counter` int(11) NOT NULL default '0'
);
I did exactly as you said, but I cannot check the BLOGLOG table, as it states it has no index defined. Also, my weblog is now filled with PHP messages (BENCH: etc.).garvinhicking wrote:Now you can fetch the staticpage that take so long to load, and check the BLOGLOG database table, so that you can see how long which SQL query took. The one that took longest, you could show/post here?
When I try to browse the table, MySQL returns an 'empty set of results' and states 'no index defined' (translating, I'm using Dutch phpmyadmin). I have already navigated the blog and opened several static pages, so it should be filled.garvinhicking wrote:But what do you mean with "it states it has no index defined"? You must browse the table with phpmyadmin, there should be rows in it?
Code: Select all
mysql_query("INSERT INTO BLOGLOG (request, timestamp, sql, exec_time, ip) VALUES
('" . serendipity_db_escape_string($_SERVER['REQUEST_URI']) . "', NOW(),
'" . serendipity_db_escape_string($sql) . "', '" . (number_format($end-$start, 10)) . "',
'" . serendipity_db_escape_string($_SERVER['REMOTE_ADDR']) . "')");
Code: Select all
mysql_query("INSERT INTO BLOGLOG (`request`, `timestamp`, `sql`, `exec_time`, `ip`) VALUES
('" . serendipity_db_escape_string($_SERVER['REQUEST_URI']) . "', NOW(),
'" . serendipity_db_escape_string($sql) . "', '" . (number_format($end-$start, 10)) . "',
'" . serendipity_db_escape_string($_SERVER['REMOTE_ADDR']) . "')");
echo mysql_error();
)I can't seem to find the code you mentioned, there is no mention of 'bloglog' whatsoever in my mysql.inc.php file.garvinhicking wrote:You mention you're intensely using the wikilinks plugin. How many wikilinks are on a single page? Each wikiling has one database lookup, so when you use many, this definitely impacts your databse, there's no real way to circumvent that (apart from not using wikilinks
Which s9y version are you using? This code is part of at least Serendipity 1.2.1I can't seem to find the code you mentioned, there is no mention of 'bloglog' whatsoever in my mysql.inc.php file.
Okay, that's true!As for the Wikilinks, this would not account for the overviews loading slowly (as they just list their subpages, and not by Wikilinking) and as for the normal SP's, they have maybe 5 to 10 Wikilinks max on them.
Hmmm, I'm still using 1.1. If there is any way of avoiding upgrading now and do this another way, that would be a lot easier. I want to upgrade eventually, but now it would just take a lot of time and extra work.garvinhicking wrote:Which s9y version are you using? This code is part of at least Serendipity 1.2.1