Hello,
Here is my situation:
7 lists. 3 lists have over 1.5 milion rows each. 6 tables are joined to a main list. In main list i need to have (beside other filters like Company name and SSN) a filter for City.
The problem is that even i use Exact match for City, i will wait way too long for a result, and sometime i got the message "Out of memory" . That because for some searching terms, the result could contain over 300.000 rows.
What can i do to properly use a filter for City element?
Thank you
Here is my situation:
7 lists. 3 lists have over 1.5 milion rows each. 6 tables are joined to a main list. In main list i need to have (beside other filters like Company name and SSN) a filter for City.
The problem is that even i use Exact match for City, i will wait way too long for a result, and sometime i got the message "Out of memory" . That because for some searching terms, the result could contain over 300.000 rows.
What can i do to properly use a filter for City element?
Thank you