Why my site is so Slowwww ?

[judebert]

Okay, Chief. I committed the plugin, and you should be able to update it from CVS (or from SPARTACUS in 24 hours).

Note that this does not fulfill all your request: it deletes RSS-feed entries that are expired, and it protects the ones with comments or extended bodies. However, it does not protect against feed deletion, which will take all the entries for that feed along with it, regardless of their comment status.

It does not delete entries that were not created from an RSS-feed. It does not add a delete option. It does not discriminate by category.

But it should clean up a good chunk of your site.

[Chief]

Thx judebert, I will try in my test site. I cant find CVS link to take the plugin and the Plugin / templates not work.

Its an hard job to put a box where we can write the number of the categories we dont want to remove entries ? Like in Start page category ?

[judebert]

You should still be able to download in SPARTACUS, unless your server is firewalled.

You can also try http://sourceforge.net/php-blog/ and browse the CVS repository, but you'll have to get the files individually.

I hope the SPARTACUS web page is back up soon. If not, I'll put the files on my server this evening.

[judebert]

You should still be able to download in SPARTACUS, unless your server is firewalled.

You can also try http://sourceforge.net/php-blog/ and browse the CVS repository, but you'll have to get the files individually.

I hope the SPARTACUS web page is back up soon. If not, I'll put the files on my server this evening.

I hesitate to call any programming task a hard job. But it would take time, and I just don't have enough for that task right now.

[Chief]

Ok I finally get the file... I make a test but for now its look not working.

I have setup

Expire content to 10 only for this test

Expire checksums to 30

Ignore updates yes

Remove dependent entries yes

did I make something wrong ? I have try debug but nothing look to have delete entries message in.


Thx

[judebert]

Now all we need is something to call the plugin so the feed entries can be expired. You can do that youself (if I'm reading the code correctly) by calling http://yourblog/yourblogdir/plugin/sere ... aggregator to activate the external_plugin hook.

Otherwise, you'd need to install the cronjob plugin to activate the cronjob hook.

It should then print each entry as it expires it.

[DW]

I am not a whiz at this stuff but am pretty handy - Built our website with front page. I am trying to start a blog on our web site and installed Serendipity. Our site is quick, but as soon as we log onto the blog it is as slow as molasses. Please help and suggest a way to speed up the blog;

Address is;

www.HomesInGuelph.ca/serendipity

Any help is appreciated.

Spoke with tech support at hosting service and they did a test and the test sql page worked really fast which indicated it was not a server problem.

Looking forward to a reply.

Thank you

[garvinhicking]

Hi!

Please tell us some details about your server: Which Database and version do you use, which PHP version, which web server and how is PHP embedded (module or FastCGI?)

Also please tell us which event plugins you installed.

So far it seems to me that you are just having the standard plugins, in which case serendipity should perform quite fast.

If possible please try to use a tool like phpMyAdmin to check your database if indexes are set on the s9y tables. Did you get any error message about missing indices when you installed serendipity?

Sadly to me this looks like a server configuration issue, not a general Serendipity issue. Do you have any other PHP/SQL intense applications running on your site? Like Mambo, Typo3, Gallery2, phpBB with many entries?

Best regards,
Garvin

[Chief]

Hi judebert, I have try the tweak to delete my entries who have over 30 days with no comments or no extended entries and its not work .. I have try in a test installation with same database but nothing.

I have also try on my principal website and no success.... may I try something else ?

Thx.

[DW]

Thanks for the prompt reply Garvin.

In response to your questions;

MySQL version 4.0.27
PHP version 4.4.1
Apache Module

I will check the tables and make sure they are indexed.

There were no errors upon installation of Serendipity.

On the side, another question? - Can public users start new topics or jus comment to admin topics?

Thanks for your assistance.

Regards,

Dave

[garvinhicking]

Hi Dave!

Okay - how about other webapps running on your server, and their responsivity?

On the side, another question? - Can public users start new topics or jus comment to admin topics?

If you want that, you can install the "User Self-Registration" plugin which allows users to register an account and write entries on your blog, yes.

Regards,
Garvin

[Chief]

Hi Garvin and judebert, is there a way to make the clean by the MySql database directly?

Same thing as the judebert modification but by phpmyadmin ?

All message old more then 30 days with no comments and is not extended.

Maybe I have too much message to delete and the aggregator modification cant handle too much.

My site is around to explode lol its display a blank page sometimes ...

Thx !

[garvinhicking]

Hi Chief!

Yes, you could do that with SQL directly. However the SQL code to perform this will get a bit complicated to code.

Best regards,
Garvin