Dear all,I’m using single category views to do search in different criterias on a DB. It has about 10000 records… and it will increase as well. i need to know whether this search will get slow in the future.
THANKS IN ADVANCE
shana
Dear all,I’m using single category views to do search in different criterias on a DB. It has about 10000 records… and it will increase as well. i need to know whether this search will get slow in the future.
THANKS IN ADVANCE
shana
Subject: Search using single category view
Is it that you are maintaining multiple Views, each of them Categorised on a particular column? And for searching, first you pick a suitable view based on the field being queried, and then pick the documents using a view lookup.
If so, I think, that’s the best approach for performance. Since you are avoiding blind searches at database level, and scoping it with help of proper views, you are likely to get good reponse even if database grows.
Regards
Litty Joseph
Subject: RE: Search using single category view
thanks a lot Litty…