I'm in the preliminary reasearch stage of a large ASP.NET project; I'm
looking for some resources (e.g., articles, books).
I'm looking to determine the feasability of developing an ASP.NET
reporting application that will hit a 200+ GB database (SQL Server 2K
and Oracle 9i) and return on average 100,000 rows per report.
This application will be used by 10 - 15 concurrent users, each
returning between 50K and 100K rows.
I'm hoping to find an appropriate design pattern for such an app. I'm
currently investigating the following:
1) Asynchronous client notification
2) Asynchronous ADO.NET
3) Spawning multiple worker threads
4) Web farms
If anyone could highlight some resources, it would be greatly
appreciated.
Joel Scavone 8 1284
Natty Gur ( http://weblogs.asp.net/NGur/) is the guy to ask.
Eliyahu
"joels" <js******@bluelance.com> wrote in message
news:97**************************@posting.google.c om... I'm in the preliminary reasearch stage of a large ASP.NET project; I'm looking for some resources (e.g., articles, books).
I'm looking to determine the feasability of developing an ASP.NET reporting application that will hit a 200+ GB database (SQL Server 2K and Oracle 9i) and return on average 100,000 rows per report.
This application will be used by 10 - 15 concurrent users, each returning between 50K and 100K rows.
I'm hoping to find an appropriate design pattern for such an app. I'm currently investigating the following:
1) Asynchronous client notification 2) Asynchronous ADO.NET 3) Spawning multiple worker threads 4) Web farms
If anyone could highlight some resources, it would be greatly appreciated.
Joel Scavone
"joels" <js******@bluelance.com> wrote in message
news:97**************************@posting.google.c om... I'm in the preliminary reasearch stage of a large ASP.NET project; I'm looking for some resources (e.g., articles, books).
I'm looking to determine the feasability of developing an ASP.NET reporting application that will hit a 200+ GB database (SQL Server 2K and Oracle 9i) and return on average 100,000 rows per report.
This application will be used by 10 - 15 concurrent users, each returning between 50K and 100K rows.
I'm hoping to find an appropriate design pattern for such an app. I'm currently investigating the following:
1) Asynchronous client notification 2) Asynchronous ADO.NET 3) Spawning multiple worker threads 4) Web farms
A single CPU server running ASP.NET would never break a sweat churning out
these reports to only 10-15 concurrent users. But, if the reports take a
long time to run on the Database server, or a long time to prepare on the
web server you will want to use a background thread to prepare the report
instead of an ASP.NET worker thread.
The basic process is:
Client requests report.
Server spawns a thread to run the report and generates a "job ticket".
Server redirects client to a page where javascript polls every X seconds to
see if the job is done.
Background thread runs the query and prepares the report, and then stores it
in global scope (Application, cache etc) under the job ticket.
Client finds that the job is completed and redirects to the report output
page which sends the saved report to the client.
David
Excellent. That fills in a few gaps with regard to my thought process.
I believe I'll start a proof of concept.
js
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
You should investigate the Data Caching and Page Caching that comes with
ASP.Net.
I already have an application that generates reports of a similar or greater
size against an SQL DB. Once you get the DB tuned and bringing back the data
quickly, ASP.Net will have no trouble handling the concurrent users on a
decent web server. You can use Datagrid and the paging - DO NOT use the
default paging though or use a third party reporting tool.
"joels" wrote: I'm in the preliminary reasearch stage of a large ASP.NET project; I'm looking for some resources (e.g., articles, books).
I'm looking to determine the feasability of developing an ASP.NET reporting application that will hit a 200+ GB database (SQL Server 2K and Oracle 9i) and return on average 100,000 rows per report.
This application will be used by 10 - 15 concurrent users, each returning between 50K and 100K rows.
I'm hoping to find an appropriate design pattern for such an app. I'm currently investigating the following:
1) Asynchronous client notification 2) Asynchronous ADO.NET 3) Spawning multiple worker threads 4) Web farms
If anyone could highlight some resources, it would be greatly appreciated.
Joel Scavone
Caching is not an option as we're looking at a 250 GB database. 10
different users may each return 100,000+ rows, and there may be
absolutely no overlap.
Additionally, custom most likely not an option as we'll be implementing
export functionality, and will need the entire set of data available to
the export process.
Thanks,
js
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Joel,
Have you considered a reporting solution? Here are some that come to
mind...
SQL Server Reporting Services http://www.microsoft.com/sql/reporting/default.asp
Crystal Enterprise http://www.businessobjects.com/produ...se/default.asp
Cognos ReportNet http://www.cognos.com/products/busin...os%20ReportNet
I'm sure there are others as well. One word of advice though, don't let
anyone convince that any of these will work perfectly out of the box.
Chances are you will still need to do a fair amount of customization to get
it working and looking how you want. But it does give you a good starting
point.
--
Brian Pursley
MCSD, MCSE, MCDBA
President, CinLogic LLC www.cinlogic.com
"joels" <js******@bluelance.com> wrote in message
news:97**************************@posting.google.c om... I'm in the preliminary reasearch stage of a large ASP.NET project; I'm looking for some resources (e.g., articles, books).
I'm looking to determine the feasability of developing an ASP.NET reporting application that will hit a 200+ GB database (SQL Server 2K and Oracle 9i) and return on average 100,000 rows per report.
This application will be used by 10 - 15 concurrent users, each returning between 50K and 100K rows.
I'm hoping to find an appropriate design pattern for such an app. I'm currently investigating the following:
1) Asynchronous client notification 2) Asynchronous ADO.NET 3) Spawning multiple worker threads 4) Web farms
If anyone could highlight some resources, it would be greatly appreciated.
Joel Scavone
SQL Reporting Services is not an option as we're reporting of an Oracle
9i environment as well as MS SServer.
Crystal does not allow for true ad hoc reporting as it will not allow
for dynamic column generation-- you must build a report with predefined
columns.
js
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
SQL Server Reporting Services is not an option as we're reporting off of
Oracle as well.
Crystal Enterprise does not allow for dynamic column generation,
unfortunately, and we need true ad hoc reporting.
js
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John Morgan |
last post by:
I have Enterprise Manager on my local machine. For the last twelve
months it has been connecting without problem to my online SQL Server
database provided by my ISP.
Three weeks ago the ISP applied some sort of extra security
arrangements to their SQL Server to allow access only through port
1433. they have told me to configure an alias...
|
by: banyanhost |
last post by:
Hello:
I have a question regarding my copy of DB2 Enterprise Edition 7.1
My business acquires used software fairly often. And we came across a
copy of DB2 Enterprise Edition 7.1 and i want to know if you can tell
me what type of license this will allow us to use the product as.
Here is what the license card says:
|
by: bjhogan |
last post by:
Hi,
I have built an c# asp.net application on my laptop, it uses the
Enterprise Library blocks -
Data Access Application Block,
Configuration Application Block.
I now want to deploy my application on a server. It does not have the
Enterprise Library installed.
|
by: zino |
last post by:
the same web application works fine on Visual studio 2003,
but it generate the follwing error on Visual Studio 2005.
Indirect reference is being made to assembly
CrystalDecisions.Enterprise.PluginManager version 10.2.3600.0, which contains
'CrystalDecisions.Enterprise.InfoStore.PluginManager'. This Project
references a prior version of...
|
by: Jonathan Crawford |
last post by:
Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable)
+473
Hi
I have installed the enterprise library on a development machine and created
a project
on our webserver. When I run a simple data access page I get an error
message. Apparently
| |
by: Patrick |
last post by:
I am using the Microsoft enterprise Library (June 2005) with .NET Framework
1.1 on a Windows 2003 IIS6 web server.
with an ASP.NET 1.1 application, I have a dataConfiguration.config as listed
at the end of this post(configured with the Enterprise Library Configuration
Tool)
I have this file in a "production" environment and what I found...
|
by: Jim Devenish |
last post by:
I am having some problems in the process of moving an Access back-end
to an SQL Server back-end. Everything works but there are severe
problems of response times when the number of users builds up.
At present we are using the Developer version before committing to the
Enterprise version. BOL (quoted below) seems to suggest that, apart...
|
by: uanmi |
last post by:
Please create an Enterprise Library Forum asap.
There is no help on gotdotnet for the many people asking questions.
My project is stuck without some answers.
--
regards, Mark
|
by: rockdale |
last post by:
Hi, all
I am using Enterprise Library for .NET Framework 2.0 - January 2006 to
access my backend MS SQL database. As now we are consider migrate sql
database to mySQL. What engine (ODBC or MySQL for .NET) should I use so
that the code change wil be minimum?
Also, as the enterprise lib using connectionstrings in web.config to
access the...
|
by: kellygreer1 |
last post by:
I'm working on some internal company web services and I have a
question about resource management within the Enterprise Data Access
Block.
I have about 20 methods which look similar to the one below:
public DataSet GetUserDataByGroup(int groupId)
{
string procName = "sp_GetUserDataByGroup";
return...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |