Hi, i have been using solr for many years and it is VERY helpful. My problem is that our app has an increasingly more complicated access control to satisfy client's requirement, in solr/lucene it means we need to add more and more fields into each document and use more and more complicated filter conditions, so code is hard to maintain and indexing becomes a serious issue because we want to search as real time as possible.
I would appreciate a high level guidance on how to deal with this issue? recently i investigated mySQL fulltext search (our app uses mySQL), using mySQL means we simply reuse DB for access control, but mySQL fulltext search performance is far from ideal compared to solr. Thanks very much for helps, Lisheng
