Database with million records and dataset

[Rujuta Gandhi]

Hi all,

I have one problem with my database as it is having millions of records and
i dont want indexing. I m using dataset to fetch the records. Can any one
tell me When all millions will be loaded in dataset will it cause any
problem on server side. After loading in dataset i m loading it in
PagedDataSet and so from server to client the page size may not cause any
problem. But i m afraid on server side this 1 million records fetching can
cause any problem or not.

And if yes can any one suggest me some solution to this.
I m using sql server for database.

thanks
Regards
Rujuta

 

[Alvin Bruney [MVP]]

Good luck with those lofty goals!

In the meantime, a web page cannot handle a million of anything, let a lone
an end-user. I suggest you start by learning the basics of web programming.
MSDN is a good place to start. It will help you design better applications.