I did set it as BINARY index. I changed all my logical field indexes
to binary a long time ago. My reasoning for what I said is that I would
have to go back to anywhere where I didn't have the READWRITE or
NOFILTER clause and expected to show the RECCOUNT() like the example I
posted, then it would be wrong. Recall my example wasn't about locating
a particular record but knowing how many it was if not a single match.
On 6/25/2020 5:07 AM, Jürgen Wondzinski wrote:
The INDEX on DELETED is absolutely ok, if you do it as a BINARY index. The
BINARY index is basically the rushmore map. Each record is represented as one
bit, thus the resulting indexmap is way smaller and faster than the traditional
indexing map.
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
