Why my site is so Slowwww ?

Post by **garvinhicking** » Mon Sep 11, 2006 2:35 pm

Hi!

You could modify that plugin that already deletes entry, and modify the SQL statement to check if entry.comments is < 1 and entry.extended != ''?

HTH,
Garvin

Chief · Post by **Chief** » Mon Sep 11, 2006 8:12 pm

I just check in the Agregator to see how its work ... I dont think I can do it myself

I dont thibk its a good idea to try it ....

Who made the Agregator module ?

Post by **garvinhicking** » Tue Sep 12, 2006 8:38 am

Hi!

I did it.

After my holidays, I can have a look at implementing your wish.

Best regards,
Garvin

judebert · Post by **judebert** » Tue Sep 12, 2006 1:53 pm

Another commit I'm almost ready to make.

I modified it to delete only entries that, besides the earlier restrictions, also have no comments and no extended body. Is that what is desired?

Post by **garvinhicking** » Tue Sep 12, 2006 1:58 pm

Hi!

That seems to be it.

) Many thanks for your help, judebert!

Best regards,
Garvin

judebert · Post by **judebert** » Tue Sep 12, 2006 2:03 pm

Since I've got you here...

I only added the comparison in expireEntries. If you delete the whole feed, everything will still go with it. Should I keep entries with comments/extendeds when their feed is deleted, or should I delete them?

Chief · Post by **Chief** » Tue Sep 12, 2006 4:31 pm

I want to delete the entries have no comments and no extended in .. if my visitor take time to comment my entries I dont want to remove these entries.

Same for extended .. if I make the extended entries its cause I want to get this entries for future comments.

Its possible to put different time for different categories ?

Like if I want to delete YouTube entries after 20 days ( too much entries there

)

and News categories after 60 days

Thx guys

judebert · Post by **judebert** » Wed Sep 13, 2006 5:01 am

No, I don't think there's (currently) any way to set the feeds separately.

There are two places where entries get deleted: one is when an existing feed's entries are expired, and the other is when a feed is deleted. I've already handled the expiration, and I'm dealing with feed deletion.

If you're deleting a feed, all the entries go with it, whether they've got comments or not. I expect this is the proper behavior, but I want to verify it first.

Chief · Post by **Chief** » Wed Oct 04, 2006 1:29 am

Hi All, Hi Garvin ... hope you have great vacation.

If you have time to check the Delete entries stuff, if you need tester tell me...

I cant find how myself ..

Thanks

Chief · Post by **Chief** » Tue Oct 17, 2006 2:56 am

Hi All ... something new here ? I need something to clean the database soon lol I have over 40, 000 entries but I dont want to delete where I have comments or extended.

Pleeaassee !

Post by **garvinhicking** » Tue Oct 17, 2006 10:30 am

Hi!

Thanks for reminding me! I'm currently a bit out of time, so I can't tell yet when I have the chance.

...( But a donation would speed up the process *big-grin*

)

Best regards,
Garvin

judebert · Post by **judebert** » Tue Oct 17, 2006 5:52 pm

I tell ya, it's amazing what a $12 CD can do. Normally that paltry sum buys less than an hour of my development time, but around here it gets weeks of dedicated support and programming. I must be crazy.

Anyway, do you need this plugin committed (I'm only slightly reluctant, since nobody has told me it's either good or bad at this point)? Or are you looking for a new plugin (perhaps based on this one) that cleans up old entries?

Chief · Post by **Chief** » Tue Oct 17, 2006 8:04 pm

LOL I hear you .. Now what I want is to speed up my website, if I can make it quicker I will leave it in this actual form, if I cant I have to find another solution.

I make website for hobby but Trust me if I use serendipity for Website and I can make money with I will support you guys.

For now you can pm me and tell me how many $$$ is required to rent your services.

thx again

judebert · Post by **judebert** » Tue Oct 17, 2006 8:14 pm

Oh, don't misunderstand: we're helping you out, and no donation is required. Certainly appreciated, but not required.

If you just need the RSS feed modifications committed, it'll take me about ten minutes after I get home tonight. Unfortunately, it only does the cleanup on expired entries, and it doesn't try to keep entries from deleted feeds. So if you delete a feed (instead of just waiting for its entries to expire), it'll take all that feed's entries, commented or not. And all categories will have the same expiration date.

If that's good for you, I'll commit it tonight.

Chief · Post by **Chief** » Tue Oct 17, 2006 10:57 pm

I understand, Yes what I want is clean in all categories all entries after like 30 days or more where I have no comments or no extended entries.

If its not enough important for my visitor or an admin to extended the entries I want to remove it.

Its possible to have a box where we can put the id of each catogories where we want to delete post ?

I have to try to speed up my site... now its very long to display and I dont want to see visitor stop to come cause its long to display.

If you have something can help me to improve the site you are welcome. My host is on windows 2003 server.

Also its possible to have another option when we edit a post ?

We have Publish and Draft ... can you add a Delete fonction ?

Many thx for your help.