• twitter image
  • facebook image
  • youtube image
  • linkedin image
Language: CMS Made Simple Czech CMS Made Simple France CMS Made Simple Spain CMS Made Simple Hungary CMS Made Simple Russia CMS Made Simple Netherlands

All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Search module index table too big
PostPosted: Wed Nov 07, 2012 7:43 pm 
Offline
Forum Members
Forum Members

Joined: Wed Oct 01, 2008 9:05 pm
Posts: 28
Hi, I run CMSMS 1.9.4.3 for a newspaper website. The site now hosts some 22 thousand articles using the news module.
I have found that the admin is slowing down.
According to my DB guy its because the cms_module_search_index table has close to 7 million rows and 224 Mb.
Can I trim down this table? What implications might this have? What alternatives do I have?
Any help would be greatly appreciated.
Thanks,


Top
 Profile  
 
 Post subject: Re: Search module index table too big
PostPosted: Mon Jan 28, 2013 7:20 pm 
Offline
Administrator
Administrator
User avatar

Joined: Thu Mar 09, 2006 5:32 am
Posts: 12381
Location: Arizona
You need to upgrade CMSMS to the latest version, we only support the last 2 versions, this may also help with the search problem...

_________________
Extensions » Modules/Tags click the name of the module/tag or Help to the right to get its parameters.
Right click and view source is a great way to see what you have to work with.
Check ver. CMSMS, PHP, server OS, in System Information page.
Default content http://multiintech.com/defaultcontent/
People are Wonderful
Business is Great
Life is Terrific
Ever wonder what happened to the Album module? Well it is alive and well.
http://album.multiintech.com/
Image


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Arvixe - A CMSMS Partner