4million db record how to display ?

[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

[Julia]

What will the user do with 4 million records?!

"Tom Gao" <to********@optushome.com.au> wrote in message
news:41***********************@news.optusnet.com.a u...

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

[Cor Ligthert]

Tom,

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

Just my thought

Cor
"Tom Gao" <to********@optushome.com.au>

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

[Shiva]

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

"Tom Gao" <to********@optushome.com.au> wrote in message
news:41***********************@news.optusnet.com.a u...
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

[John Wood]

Have a look at this Microsoft article on implementing paging with the
datagrid:
http://support.microsoft.com/kb/307710/EN-US/

John Wood
Blog: http://spaces.msn.com/members/johnwood

"Tom Gao" <to********@optushome.com.au> wrote in message
news:41***********************@news.optusnet.com.a u...

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

[James Curran]

"Tom Gao" <to********@optushome.com.au> wrote in message
news:41***********************@news.optusnet.com.a u...

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 ?

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

[rkc]

Tom Gao wrote:

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 ?

Implement a search option.