WebServer to host ASP.NET applications

  • Thread starter Thread starter Aspiring .NET Programmer
  • Start date Start date
A

Aspiring .NET Programmer

This is one of the fundamental questions I have. Would greatly
appreciate any response.

I have been using and still use IIS for hosting my ASP.NET
applications. As the size of the application grows and the number of
users accesing the application grows to lets say 100 or more, is IIS
still a good option or which are the other more powerful and scalable
options for servers available.

Thanks!
Sum
 
Well, if microsoft.com is using IIS i think you started to worry a little
early about IIS ability to handle 100 users :)

George.
 
Thank you guys!...Would the hardware cofiguration of the machine on
which IIS is running have an affect on the performance? Will a more
powerful machine with bigger memory and processing power perform
faster. How do we determine whats good enough??


The following question may be a little out of scope for this group but
its valid for large asp.net web applications so here we go..

My app sometime referes to SQL Server tables that has around 2 million
records in them. Even a simple statement like "select column1 from
table1, table2 where table1.id= table2.id and table1.id=XYZ" over two
such large tables causes the application to slowdown drastically and
sometimes timeout since the result set was not fetched in time. Again,
willl a more powerful machine give better performance? FYI: The same
sql statement takes something like 2 mins in the Query Analyzer.

Thanks!
Sum
 
Thank you guys!...Would the hardware cofiguration of the machine on
which IIS is running have an affect on the performance? Will a more
powerful machine with bigger memory and processing power perform
faster.
Click to expand...

Generally speaking, yes, though bigger and faster hard disk(s) will also
help too...
How do we determine whats good enough??
Click to expand...

There's really no easy answer to this one - however, this wouldn't be a bad
place to start:
http://www.microsoft.com/downloads/...5a-062a-439e-a67d-75a89aa36495&DisplayLang=en
My app sometime referes to SQL Server tables that has around 2 million
records in them. Even a simple statement like "select column1 from
table1, table2 where table1.id= table2.id and table1.id=XYZ" over two
such large tables causes the application to slowdown drastically and
sometimes timeout since the result set was not fetched in time. Again,
willl a more powerful machine give better performance? FYI: The same
sql statement takes something like 2 mins in the Query Analyzer.
Click to expand...

This begs the obvious question: are your tables properly indexed? *Storing*
2 million records will not phase SQL Server one bit. However, if you're
trying to *fetch* 2 million records from your database to your webserver,
then you really need to rethink your application...
 
Generally speaking, yes, though bigger and faster hard disk(s) will also
help too...


There's really no easy answer to this one - however, this wouldn't be a bad
place to start:http://www.microsoft.com/downloads/details.aspx?FamilyID=e2c0585a-062...


This begs the obvious question: are your tables properly indexed? *Storing*
2 million records will not phase SQL Server one bit. However, if you're
trying to *fetch* 2 million records from your database to your webserver,
then you really need to rethink your application...
Click to expand...

Thanks for your reply! I will take a look at that tool you suggested.

There are two extremes of the resultset we expect from the tables.

1) Fetch just a few records out of the 2 millon records that satisfy a
certain criteria (where clause) after a join operation among large
tables and display in a DataGrid.

2) Get all the records from 2 tables with 2 million records each and
have some relationship associated with them without any where clause
and populate the same DataGrid.

Its basically a search module where the user is given 5 parameters to
fillin their search criteria. If the user want to just get all the
records he doesnt provide any search criteria and clicks on search.
This seach needs to access these huge tables.

In both cases there is obviously a join operation on 2 large tables.
It takes around 2-3 mins for such a query to run even in SQL Server
Query Analyzer or Enterprise Manager. How do we improve this in the
first place? If we just look at the first scenario for now, there isnt
a problem with loading large amount of data into the webserver since
we are only fetching a few(10 records for eg.) records and only those
would be loaded into the webserver.

Thanks for ur time.

Sum.
 
Thanks for your reply! I will take a look at that tool you suggested.
Click to expand...

It's not the most sophisticated stress-test tool available, but it's free,
and is made by the people who wrote the server software in the first
place... :-)
2) Get all the records from 2 tables with 2 million records each and
have some relationship associated with them without any where clause
and populate the same DataGrid.
Click to expand...

To my mind, that is utter lunacy on a web app... What on earth do yon need
to display 2 million records on a web page for...?
In both cases there is obviously a join operation on 2 large tables.
It takes around 2-3 mins for such a query to run even in SQL Server
Query Analyzer or Enterprise Manager.
Click to expand...

Post your SQL...
 
Back
Top