Author Topic: Search feature takes 15 minutes to find a company, which makes software unuseabl  (Read 2682 times)

stardisplays

  • Member
  • *
  • Posts: 12
When doing a search on The organization name field it take s 15 minutes to perform a simple search which makes core3  non useable due to slow performance. In a large data base.  When your prospect lists grows, then ones performance goes away. No one want to use the software at this point, unless there a trick to check?

Jerel Malong

  • Global Moderator
  • Member
  • *****
  • Posts: 97
True, in larger data sets of over 100,000 records, our Core3 is indeed searching through a calculated organization field to perform a standard find which can really affect performance. For Smaller data sets, there appears to be no problem. In the Core4 and in later versions of the Core3, we now default the find to the local organization field instead which brings the find speeds back down to 1 second or so for even the largest of data sets.  Existing Core3 customers can change their version by selecting the "Name_Organization" field when entering find mode instead of the "zz_Display_Organization__ct" field.  You can make this same change on the field's "Quick Find" option as well.

BlueBottle

  • Member
  • *
  • Posts: 1
True, in larger data sets of over 100,000 records, our Core3 is indeed searching through a calculated organization field to perform a standard find which can really affect performance. For Smaller data sets, there appears to be no problem. In the Core4 and in later versions of the Core3, we now default the 3 Week Diet from https://skinnyexpress.com/the-3-week-diet-review find to the local organization field instead which brings the find speeds back down to 1 second or so for even the largest of data sets.  Existing Core3 customers can change their version by selecting the "Name_Organization" field when entering find mode instead of the "zz_Display_Organization__ct" field.  You can make this same change on the field's "Quick Find" option as well.

This was happening to me but I found that splitting up data made things run much smoother.
« Last Edit: May 28, 2016, 11:55:58 AM by BlueBottle »