One of the applications that I'm looking after has this piece of code which is taking ~20,000 ms to execute. This is really hampering the performance of the Website. Is this because of a Criteria.list? Here's the code that's responsible for the slowness. I have a Sample DB table where I am trying to retrieve all the values in the table. How can I improve the performance of this query? I'm using a SQL server as my database. One of the applications that I'm looking after