Community
Showing results for 
Search instead for 
Do you mean 
Reply

Is there a Query limit

Tuned Listener
Posts: 77
Country: United States

Is there a Query limit

I use Premium 2009.

 

My database has about 22,000 contacts. When I do a search in notes - is there a limit to the number of contacts it will return if there is a match on the criteria?

 

I know that the previous Premium for Workgroups only returned the first 1000 contacts.

 

Thanks.

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Is there a Query limit

There is no known limit to the number of records that can be returned in a lookup or advanced query.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Tuned Listener
Posts: 77
Country: United States

Re: Is there a Query limit

I just did a search on my 22K contacts database on a word I know that is used in over 1000 contacts. It returned a mess saying that "records found exceeds search limit. Consider narrowing search criteria".

 

Can you please say what you mean by no known limit?

 

Thanks

Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: Is there a Query limit

From the way you worded what you were doing the query for I'm assuming that you were doing a keyword lookup. It would be good if you specified. If so, I can believe that would have a limit because of the preview. I don't believe there is any limit to a regular lookup or an advanced query.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Tuned Listener
Posts: 77
Country: United States

Re: Is there a Query limit

I was very specific in my original posting. It said I was searching notes. The ACT person here said there is no known limit. When I did the search, there is a error that occurs as indicated in my last reply.

Moderator
Posts: 4,395
Country: USA

Re: Is there a Query limit

Keyword search is limited to 1000.  Greig must have misread the post, as he stated advanced query and lookup.
Tuned Listener
Posts: 77
Country: United States

Re: Is there a Query limit

Can you please say why there is a limit of 1000? Why is Sage limiting such a function?