4million db record how to display ?

  • Thread starter Thread starter Tom Gao
  • Start date Start date
T

Tom Gao

Hi guys I have 4 million records in a table in one database...

I want to display it in a datagrid... how can I do this efficiently ?

please be specific should I do it in sql server or in .net ?

Thanks
Tom
 
Tom,

In my opinion should you in one or the other way page it
GrandParend -> Parent -> Child >

Just my thought

Cor
 
How about paging? May be 10-20 records at a time?

Hi guys I have 4 million records in a table in one database...

I want to display it in a datagrid... how can I do this efficiently ?

please be specific should I do it in sql server or in .net ?

Thanks
Tom
 
Tom Gao said:
Hi guys I have 4 million records in a table in one database...

I want to display it in a datagrid... how can I do this efficiently ?

please be specific should I do it in sql server or in .net ?
Click to expand...

Step one, turn off ViewState for the Datagrid, and do the query on every
postback.

Next, You'll have to determine for yourself which way is better for your
particular environment. Reading the entire 4M records and letting the
DataGrid figure out which ones to show would probably be the easiest way to
go, but re-selecting 4M records every postback will put a strain on your
data server.

--
Truth,
James Curran
[erstwhile VC++ MVP]
Home: www.noveltheory.com Work: www.njtheater.com
Blog: www.honestillusion.com Day Job: www.partsearch.com
 
Tom said:
Hi guys I have 4 million records in a table in one database...

I want to display it in a datagrid... how can I do this efficiently ?

please be specific should I do it in sql server or in .net ?
Click to expand...

Implement a search option.
 
Back
Top