Using Devart or NHibernate

Question

Dear All I have project which manage so much data. sometimes I must show data almost 1 million row. If I have 2 choice to solve it and I want to make it more faster when show data what technologies better I choose between Devart or NHibernate? I`m using PostgreSQL as database and want to show data as fast as possible

rgrds

Answer 1

If you are going to show a 1 million of rows then any ORM is not your choice.

Answer 2

I can hardly imagine that you really want to show 1 million rows at once.
Even if you have one big table with a million rows, you will probably show them in a form or on a page which allows filtering and/or paging, so your users will only see a few rows at a time.

So I think what you really want is to select, let's say, 50 or 100 rows at once from your big table with a million rows.
For that, you can use ADO.NET or any ORM you want. They all do basically the same, it's just a matter of personal preference and there's no notable performance difference when used with this amount of data.

If you really want to load the whole million rows at once, well...you will get performance problems anyway, no matter what data access technology you use. Even with ADO.NET and a DataReader.

And even if performance would not be an issue...it still makes no sense to me.
What do your users do with a million rows of data, all shown at once? They can't see them all at the same time anyway.