Performance - User defined query / filter to search data

Posted by Cagatay Kalan on Stack Overflow See other posts from Stack Overflow or by Cagatay Kalan
Published on 2010-04-17T16:30:49Z Indexed on 2010/04/17 16:33 UTC
Read the original article Hit count: 248

Filed under:
|
|
|

What is the best way to design a system where users can create their own criterias to search data ? By "design" i mean, data storage, data access layer and search structure.

We will actually refactor an existing application which is written in C# and ASP .NET and we don't want to change the infrastructure. Our main issue is performance and we use MSSQL and DevExpress to build queries. Some queries run in 4-5 minutes and all the columns included in the queries have indexes.

When i check queries, i see that DevExpress builds too many "exists" clauses and i'm not happy with that because i have doubts that some of these queries skip some indexes.

What may be the alternatives to DevExpress? NHibernate or Entity Framework? Can we build dynamic criteria system and store these to database in both of them ?

And also do we need any alternative storage like a lucene index or OLAP database?

© Stack Overflow or respective owner

Related posts about criteria

Related posts about filter