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

What will the user do with 4 million records?!

"Tom Gao" <(E-Mail Removed)> wrote in message
news:41dbd09a$0$13283$(E-Mail Removed)...
> 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


"Tom Gao" <(E-Mail Removed)>

> 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
>
>

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

"Tom Gao" <(E-Mail Removed)> wrote in message
news:41dbd09a$0$13283$(E-Mail Removed)...
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

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" <(E-Mail Removed)> wrote in message
news:41dbd09a$0$13283$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:41dbd09a$0$13283$(E-Mail Removed)...
> 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

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.