CODEWITHSUNDEEP
c#performancenhibernatesearch
masoud ramezani
masoud ramezani

Reputation: 22950

How can we enhance our serach performance in a large application that works with NHibernate?

How can we enhance our serach performance in a large application that works with NHibernate?

Upvotes: 0

Views: 64

Answers (2)

Giorgi
Giorgi

Reputation: 30883

What about using Full-Text Search or Lucene.Net?

Upvotes: 0

Stefan Steinegger
Stefan Steinegger

Reputation: 64638

This is a rather general question. It always depends on what you search in what data structure.

So I can only give you general advises:

  • Use indexes
  • optimize the data structure, for instance by avoiding joins paths and avoid conditions
  • optimize HQL
  • use query batches
  • use select new
  • in very special cases, use native sql or views

Upvotes: 3

Related Questions