Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT! 6 email address lookup painfully slow

Copper Super Contributor
Posts: 93
Country: USA

ACT! 6 email address lookup painfully slow

We all have those customers that have ACT! as a rolodex and no reason to upgrade, especially a mom and pop like my current customer.  I've removed all the cobwebs in my brain about ACT! 6 but can't seem to solve for my customer.

 

The issue at hand is whenever they perform a lookup by email address it takes several minutes (3-5) to perform a lookup.  I have performed the following:

 

Compress & Reindex

deleted email index file and let ACT! rebuild

deleted all index files and let ACT! rebuild

 

lookup works fine for the first day then back to a snails crawl for each lookup.

 

Windows 7

ACT! 6 (latest updates installed)

no email integration

 

I'm thinking if push comes to shove I'll simply create a character field entitled email and copy all the data from the ACT! email field to it and index that field (since ACT! email fields cannot be indexed in ACT! 6).


any ideas how to address this issue?  Thanks!

 

Olga A. Garate
SoCal CRM Advisors
olga@socalcrm.com
949.836.0288
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: ACT! 6 email address lookup painfully slow


olgagarate wrote:

 

Compress & Reindex

deleted email index file and let ACT! rebuild

deleted all index files and let ACT! rebuild

 

The ACT! 6 Compress and Reindex deletes and rebuilds all the index files.

 

lookup works fine for the first day then back to a snails crawl for each lookup.

 

Windows 7

ACT! 6 (latest updates installed)

no email integration

 

I don't consider ACT! running on Windows 7 a stabel configuration

 

 

I'm thinking if push comes to shove I'll simply create a character field entitled email and copy all the data from the ACT! email field to it and index that field (since ACT! email fields cannot be indexed in ACT! 6).


The E-mail "field" that you see in the layout is not a field in the main database table but rather a portal to the separate E-mail table. That is why E-mail is not available as a data type and why you can't sort by e-mail address or use E-mail in the duplicate checking. The E-mail table can hold more than one E-mail address for a user but only the default address can be used for addressing an e-mail message

 

 


 

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Super Contributor
Posts: 93
Country: USA

Re: ACT! 6 email address lookup painfully slow

Thanks Roy, I had that as my next step IF no other option was available.  

 

Looks like I'm there.

Olga A. Garate
SoCal CRM Advisors
olga@socalcrm.com
949.836.0288