2

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

Gianni Rivera
  • 95
  • 2
  • 7
  • Please explain what "Show data almost 1 million row" actually means? Are you going to allow user to scroll down a grid containing 1 million rows. I think you need to check this question. – Rippo Jan 28 '11 at 16:23

2 Answers2

3

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.

Christian Specht
  • 35,843
  • 15
  • 128
  • 182
1

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

Sly
  • 15,046
  • 12
  • 60
  • 89
  • 2
    Well. You can use NHibernate with Stateless session. But when amount of data is really big then Stored procedures and ADO.NET probably the best option – Sly Jan 28 '11 at 11:44