>Questions: >Under �Query,� I get the message �Unindexed Records to Search: [number records] Processing Field �FIND MBR STATUS� and the search takes several minutes. This message does not appear when I do a �Find� and the �Find� only takes seconds. Why?
FIND MBR STATUS is a computed field and hence not indexable. If you use date ranges in the Expire field those dates are indexed so the query is fast. A FIND on the FIND MBR STATUS field would be slow. QUERY is just a script that uses FIND under the covers. ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------
