CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Search timing out after contact import
Pages: [1]

Author Topic: Search timing out after contact import  (Read 459 times)

bpmccain

  • I post frequently
  • ***
  • Posts: 255
  • Karma: 5
  • CiviCRM version: 4.1
  • CMS version: Drupal 7.12
  • MySQL version: 5.2
  • PHP version: 5.2
Search timing out after contact import
July 11, 2011, 08:52:45 am
So I've just finished an import of a large number of contacts into the db using the API (thanks to help from members here!). I've now got some 550,000 contacts in my database.

The problem now is that virtually all of my search functionality seems to have disappeared due to timeouts. Unless I am searching for a very small dataset (i.e. an individual person, a specific name, or external identifier), my search times out. Even with small datasets it is still sometimes timing out, or if not, taking a very long time.

Has anyone experienced this before? Is there anyway to optimize the db to fix this problem? Or other solutions? It's more or less a dealbreaker for using CiviCRM for this organization.

Brian

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Search timing out after contact import
July 11, 2011, 09:02:45 am
1. whats your hosting provider / plan. I'm assuming u r on a VPS / dedicated plan. If not, you should definitely get one :)

2. Check and tweak the settings in a url similar to:

http://drupal.demo.civicrm.org/civicrm/admin/setting/search?reset=1

I would disable the first 5 settings to start with. There is a BIG tradeoff between speed and functionality

Ultimately we need to go to a more text based search engine like SOLR

lobo

A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

bpmccain

  • I post frequently
  • ***
  • Posts: 255
  • Karma: 5
  • CiviCRM version: 4.1
  • CMS version: Drupal 7.12
  • MySQL version: 5.2
  • PHP version: 5.2
Re: Search timing out after contact import
July 11, 2011, 10:45:23 am
Thanks Lobo, turning off those five settings made a huge difference! It had been months since I originally set the site up, so I completely forgot about the search settings. Search is working much better now.

For completeness, I'll answer part 1 of your questions as well:

Right now I am just hosting locally on my windows machine running xampp.

I have a VPS up and running for when I go live, but I haven't moved the database over to it yet. I guess I could do that and test it out. My VPS is 1G RAM right now, but I can upgrade depending on requirements.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Search timing out after contact import

This forum was archived on 2017-11-26.