Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Is the ado.net convenient for an internet webapl?

Author  Topic 

chorofonfilo
Starting Member

40 Posts

Posted - 2008-04-01 : 01:23:06
Hello to all there, thank you very much for reading this post and help me to understand this better.

I am gonna build a web application that will be working all over the internet with tons of users interacting with it, till now i have just developed applications that use a browser into an intranet environment, they were dependant of a local server that managed a limited number of users so their requests werent a huge problem for the local server to deal with and thats why i always used datasets, datatables, datareaders, even storing some of this objects into session variables to avoid a deletion action from the server after the request was finished, now i have just read an article that remarks how this methodology is a big limitation for a webapplication that is gonna be working through the internet due to its high dependance of the web server memory availability, causing a big problem for the hardware support when the webapplication handles a lot of traffic.

I would like you to help me to figure if this is a real issue, if it is ok to keep ussing datasets, datatables, dataviews, datarows, etc to store and manage the data, or if i should use another data access technology available on asp.net to make of my application an efficient, fast, and scalable one. if its possible with some theoric references too about which would be more convenient in this case.

Thanks for your time reading this, your help will be really appreciated.

Peace.


Perseverance worths it...:)
   

- Advertisement -