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

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
NoidaOK, I will suggest you. 15,000 rows for a select is a lot of data to displa
y
in an ASP.NET web application. Are your users realistically going to need to
see all 15,000 rows? why not have a more restrictive select with some sort
of paging mechanism if they want to move to the next page of results?
Peter
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net
"Mukesh" wrote:

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

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

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
NoidaOK, I will suggest you. 15,000 rows for a select is a lot of data to display
in an ASP.NET web application. Are your users realistically going to need to
see all 15,000 rows? why not have a more restrictive select with some sort
of paging mechanism if they want to move to the next page of results?

Peter
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net
"Mukesh" wrote:

Quote:

Originally Posted by

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

Hi Deepti,

Although you're not directly displaying all 15,000 records to end-user
(used DataTable.Select to filter), it's still not a good idea to cache all
15,000 records at server-side.

I would suggest to optimize at the database side: with careful index
design, I think you should get good performance when frequently selecting
from the table. After all, the database server also does pretty well to
cache data for frequently queried data.

Hope this helps.

Regards,
Walter Wang (wawang@.online.microsoft.com, remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Performance Testing...

Hi,
Now I am developing C#.net Web Application. It is almost completed. Now I
want to check performance testing of it. I want...
1) Create 100 user environments, mean 100 users simultaneously request a
same page I want to see response time and load on server.
2) As per my idea we can use test project it has web base test and load test
inbuilt in Microsoft visual studio Whidbey.
Any one has idea about Load test in Microsoft visual studio Whidbey?
BYE.
Samir (Software Developer, Ahmedabad, INDIA).The tool is called Application Center Test and it ships with Visual Studio
.NET Enterprise Architect (2003). With Whidbey (2005), you need to look at
the Team tools (beta 1 refresh or the earlier Community Technical Previews).
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Samir Patel" wrote:

> Hi,
> Now I am developing C#.net Web Application. It is almost completed. Now I
> want to check performance testing of it. I want...
>
> 1) Create 100 user environments, mean 100 users simultaneously request a
> same page I want to see response time and load on server.
>
> 2) As per my idea we can use test project it has web base test and load te
st
> inbuilt in Microsoft visual studio Whidbey.
>
> Any one has idea about Load test in Microsoft visual studio Whidbey?
>
> BYE.
> Samir (Software Developer, Ahmedabad, INDIA).
>
>
You should use Microsoft's Web Application Stress Tool (WAST) to stress test
your web application. It can be found at:
http://www.microsoft.com/technet/ar...es.m
spx
Ben Lucas
Lead Developer
Solien Technology, Inc.
www.solien.com
"Samir Patel" <sneelm@.yahoo.co.in> wrote in message
news:eqVEuDalEHA.1152@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Now I am developing C#.net Web Application. It is almost completed. Now I
> want to check performance testing of it. I want...
>
> 1) Create 100 user environments, mean 100 users simultaneously request a
> same page I want to see response time and load on server.
>
> 2) As per my idea we can use test project it has web base test and load
test
> inbuilt in Microsoft visual studio Whidbey.
>
> Any one has idea about Load test in Microsoft visual studio Whidbey?
>
> BYE.
> Samir (Software Developer, Ahmedabad, INDIA).
>

Performance Testing...

Hi,

Now I am developing C#.net Web Application. It is almost completed. Now I
want to check performance testing of it. I want...

1) Create 100 user environments, mean 100 users simultaneously request a
same page I want to see response time and load on server.

2) As per my idea we can use test project it has web base test and load test
inbuilt in Microsoft visual studio Whidbey.

Any one has idea about Load test in Microsoft visual studio Whidbey?

BYE.

Samir (Software Developer, Ahmedabad, INDIA).You should use Microsoft's Web Application Stress Tool (WAST) to stress test
your web application. It can be found at:

http://www.microsoft.com/technet/ar...s/webstres.mspx

--
Ben Lucas
Lead Developer
Solien Technology, Inc.
www.solien.com

"Samir Patel" <sneelm@.yahoo.co.in> wrote in message
news:eqVEuDalEHA.1152@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Now I am developing C#.net Web Application. It is almost completed. Now I
> want to check performance testing of it. I want...
>
> 1) Create 100 user environments, mean 100 users simultaneously request a
> same page I want to see response time and load on server.
>
> 2) As per my idea we can use test project it has web base test and load
test
> inbuilt in Microsoft visual studio Whidbey.
>
> Any one has idea about Load test in Microsoft visual studio Whidbey?
>
> BYE.
> Samir (Software Developer, Ahmedabad, INDIA).