Performance of datatable.select() func against database query or the xquery

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hi all

I am developing a webportal on VS2005 and ASP.NET 2.0
Using MsSQL SERVER 2005.
I have some static records(around 15000) in the database.These contents never changed while the application is running.

what i m doing is querying the database only once at the application_start event of the global.asax file and storing the records in dataset...and further no query to database is done for this data. wherever I need this data I fetch it from the dataset...through datatable.select(filter expression) method.this is done several time for a single page request and the website is high traffic portal.

Is it an efficient way of doing or there is any other better way by which I can achieve the same..,as the amount of data is very large...approx 15,000 records.
Plz Suggest me ..........


Thanxxxxxxxxxxxxxx

Regards

Deepti Yadav
Noida
.

Relevant Pages

  • Re: Using SQl to store aspx pages and memory problems
    ... I've seen classic ASP applications design this way that work ... database isn't some sort of magic pixie dust that solves all problems. ... > the memory increases - the slowness of the request could be dealt with by ... >> takes to get the page from SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: URGENT: Application_Start - doesnt fire
    ... Your application start is firing correctly because you can request a page. ... I have>> stopped and started the Web site via IIS Manager. ... This particular Web application connects to a>> database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Need Help To Create a Function For Parameter Query
    ... >> function up with prompts ... > adds your question and the answers to the database of answers. ... >> I have a query named Status. ... >> Request Date. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Oracle 10g Express & VB6, replace MSAccess, I hope so
    ... I'll check SQLite off the list. ... Client/Server Applications ... you should consider using a client/server database engine instead ... Each request is managed ...
    (microsoft.public.vb.database.ado)
  • Re: Simple (?) Singleton Question
    ... actually being created with each request. ... Wherever you need the singleton, you just have to call the getInstance ... I might have several business classes which access tables in the database. ... The singleton class for the database means each of the business classes can get the one instance of the database class. ...
    (comp.lang.php)