ACT! 6 email address lookup painfully slow

[olgagarate]

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!

[Roy_Laudenslager]

---

@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

---

[olgagarate]

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

Looks like I'm there.