Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 27 Sep 2010, 09:25
Log on Log on is offline
 
Join Date: Aug 2009
very slow forum

Dears,

I have since long time a problem with my forum it is (Very Slow) I contacted my Hosting site, they said my Database is too large.

Details:

- Database size 397 MB
- Post table size: 160 MB
- Postparsed table size: 145 MB
- All Attachments, Averts, album Pic, ...ets (All saved on server not on the Database)
- I installed VB optimize plug-in long time ago

They advice me to empty the post table but I refuse because (forum without post is nothing), then they said I have to optimize my database (I don't know how)

Please if any one can help me to solve this problem reply to me with the solution..

Appreciated in advanced
Reply With Quote
  #2  
Old 27 Sep 2010, 09:29
metrika metrika is offline
 
Join Date: Nov 2007
Log in to Admin panel > Maintenance (left and down column) > Repair Otimize Tables > Mark "Check All" > In Option Window click on "continue"


Also try to prune posts and users

Last edited by metrika; 27 Sep 2010 at 09:35.
Reply With Quote
  #3  
Old 27 Sep 2010, 09:31
Log on Log on is offline
 
Join Date: Aug 2009
i already did the repair of the tables... but nothing happend..

but I didn't got you about prune psots and users ?!

Last edited by Log on; 27 Sep 2010 at 09:37.
Reply With Quote
  #4  
Old 27 Sep 2010, 23:38
tyteen4a03 tyteen4a03 is offline
 
Join Date: Sep 2008
Prune very old posts, and prune those 0-post users.
Reply With Quote
  #5  
Old 28 Sep 2010, 07:26
Log on Log on is offline
 
Join Date: Aug 2009
Originally Posted by tyteen4a03 View Post
Prune very old posts, and prune those 0-post users.
whould you tell my the exact way to do it quickly ?
Reply With Quote
  #6  
Old 28 Sep 2010, 12:31
tyteen4a03 tyteen4a03 is offline
 
Join Date: Sep 2008
Prune old posts:
Admin CP >> Threads & Posts >> Prune
Normally I would say the oldest 5% posts, but it is your choice.
Prune 0posts user:
Admin CP >> Users >> Prune / Move Users
Posts is less then 1 post should be ok.
Reply With Quote
  #7  
Old 29 Sep 2010, 13:40
Log on Log on is offline
 
Join Date: Aug 2009
the users with ZERO post will deleted in this case ?

--------------- Added 29 Sep 2010 at 13:45 ---------------

Really I need a way without deleting Posts or Members !!

Last edited by Log on; 29 Sep 2010 at 13:45. Reason: Auto-Merged DoublePost
Reply With Quote
  #8  
Old 06 Oct 2010, 08:00
Log on Log on is offline
 
Join Date: Aug 2009
any update
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 12:29.

Layout Options | Width: Wide Color: