Server admistrator needed!!

Boonex 7.09 site hosted with www.server4you.com.

The site is:www.indimusic.tv.

I need to clean up blogs!!! I wish to only have blogs go back 90 days and delete the rest.

My current server administrator can't figure that out. Our site is extremely slow and constant high 5 min load average errors. I need to tweak the server for our very big site and trim a good portion of the blogs off out of the database.Hourly rate to do this and re-tweak the server to run better for  our current site needs.Thank you! Contact cpati@indimusictv.com or call at 1-631-585-5380!

yeah the site is very very very slow...

i waited over 3 min and nothing showed up in browser!

to delete the blogs just do delete * from 

bx_blogs_posts where postdate <= 'your date'

good luck

This should remove the blogs older than 90 days. Its not tested so be careful with it.

DELETE FROM `bx_blogs_posts` WHERE `PostDate` < (UNIX_TIMESTAMP() - (90*24*60*60));

Your site isn't loading for me btw, maybe its too overloaded.

Where (what file and from where...Boonex/cpanel/whm etc...)is this command specifically suppose to go? I am not a programmer but very much appreciate your help!!!!

cpanel -> phpmyadmin -> dolphin database(whatever it is) -> sql from top menu

paste it and click "Go"

But i would suggest to get this verified from your programmer, it might be very dangerous. backup first :P

You have a PM

I can give you couple quick suggestions, your site is fast except for home page.

Check this, yes your going to need some tuning but this page loads and three seconds and the song streams fast!

http://indimusic.tv/m/videos/view/You-re-Turning-Into-John-Wayne-Twin-Atlantic-wmv

http://gtmetrix.com/reports/indimusic.tv/RAytIyyI

[edit]Remove the members, spy and recent blogs if there.. remove what ever is pulling data, try one block at a time for now.

I have changed your home page, it now loads in three seconds give or take a couple.

I removed the spy, and members blocks...

[edit] I also added the "HUMAN" question to your join form, that will stop most spam accounts which is your problem.

I turned on all your spam options, you need an akismet key, send it to me PM.

Leave the blogs for your backlinks.

http://gtmetrix.com/reports/indimusic.tv/MsKTnufZ

why not continue this in email or pm's ?  no need to carry out conversations in the forums.  just my two cents.

 keep your two cents then...

His site has 200k members and if those blocks are on the homepage, his site is slow.

I think this is very relevant to members and webmasters who's main page might be slow.

Why do you waste my time making me respond?

because you are stating to him what you have done to his site like it's an email system or something and what's the member count have to do with anything ?

The loading time of his home page.

Oh wait if forgot, you actually charge to help others most time.

Who made you a moderator all the sudden, don't like the topic, don't post.

Relax, newton.  Jay was only suggesting you switch over to PMs, not demanding it.

 I am doing most via PM's

I still think this is important! The guy is lost without some type of help. The spy and member blocks bring his server to a crawl.

And BTW, I know he contacted you about a new server and I firmly suggested he move there until I noticed this problem.

I still suggest he moves from his current host to you guys because he wants to.

So you know what I want to say...

200k members and only 2 people online.. might also want to do some member cleanup

do u have any videos from places or something in that particular page that could be slowing your site down a little, as I have experienced this problem before

 the problem was resolved somewhat by removing the "spy and members" blocks on the index page.