Hi Guys,
I have a doubt which is little bit conceptual rather than a coding
convention.
I have a a table called products in which I have 40000 and odd products
which is expected to be frequently
accessed by the website. I'm having doubt in how fast i can serve this
product details to the requesting clients.
Basically, I have created necessary stored procedures to pull out the data
from the database. Now, I'm planning to have
a data access layer called product (a class) which contains properties,
enumerators etc., to load all the product details
by executing the stored procedure. That is, the data access layer will be
used by the business layer to deal with the product
details in the means of populating it in the webpage, filtering etc.,
So, the product class inherits Collectionbase class to have all the
enumerator, indexer funtionalities which is nothing
but a custom data source and which can be used with DataGrid etc., and all
the business logic like how to populate, what
to populate has been written in the business layer (it uses the data layer
to define the bl), which is eventually used by
the web developers to design the dynamic pages of the site.
I'm having doubt whether this kind of approach will work best in web
atmosphere rather than a windows application or not?
and also loading 40,000 records in a collection base object will give better
performance or not?
Please kindly suggest me, how to proceed in the terms of which is better way
to deal with this.
Thanks in Advance
Vadivel Kumar 4 1273
I would put this way- if you are going to pull all 40K records in the
collection class and your web site will have multiple visitors (that means
multiple instances of the same class would be urnning in memory)- you are
definitely experience performance problem. If the business logic permits, I
would only pull the records necessary.
Also, .NET has memeory problem with larger objects (40K records is
definitely one of that kind). You are on the right track to analyse the
problem but you may have to compromise some performance to keep the business
logics flowing.
Prodip
"Vadivel Kumar" <do********@spam-i-love-u.com> wrote in message
news:uB**************@TK2MSFTNGP14.phx.gbl... Hi Guys,
I have a doubt which is little bit conceptual rather than a coding convention.
I have a a table called products in which I have 40000 and odd products which is expected to be frequently accessed by the website. I'm having doubt in how fast i can serve this product details to the requesting clients.
Basically, I have created necessary stored procedures to pull out the data from the database. Now, I'm planning to have a data access layer called product (a class) which contains properties, enumerators etc., to load all the product details by executing the stored procedure. That is, the data access layer will be used by the business layer to deal with the product details in the means of populating it in the webpage, filtering etc.,
So, the product class inherits Collectionbase class to have all the enumerator, indexer funtionalities which is nothing but a custom data source and which can be used with DataGrid etc., and all the business logic like how to populate, what to populate has been written in the business layer (it uses the data layer to define the bl), which is eventually used by the web developers to design the dynamic pages of the site.
I'm having doubt whether this kind of approach will work best in web atmosphere rather than a windows application or not? and also loading 40,000 records in a collection base object will give
better performance or not?
Please kindly suggest me, how to proceed in the terms of which is better
way to deal with this.
Thanks in Advance Vadivel Kumar
On Tue, 15 Feb 2005 08:46:01 -0600, "Prodip Saha" <ps***@bear.com>
wrote: Also, .NET has memeory problem with larger objects (40K records is definitely one of that kind). You are on the right track to analyse the problem but you may have to compromise some performance to keep the business logics flowing.
40k records would be a large collection of many small objects - which
can cause problems too.
--
Scott http://www.OdeToCode.com/blogs/scott/
For example, my data layer contains a class called "product" which inherits
IEnumerator interface and this
class is used by business layer class "products" in which
i have written all my business logic etc.,
So, while retriving the any number of product i'm iterating
from product class in products class.
Is this makes sense and I'm following the standards? and If i follow the
standards i have to give up the price of performance. So, is this shows the
standards are not right?
I'm literrally confused. Advice me.
Thanks & Regards
Vadivel Kumar
"Vadivel Kumar" <do********@spam-i-love-u.com> wrote in message
news:uB**************@TK2MSFTNGP14.phx.gbl... Hi Guys,
I have a doubt which is little bit conceptual rather than a coding convention.
I have a a table called products in which I have 40000 and odd products which is expected to be frequently accessed by the website. I'm having doubt in how fast i can serve this product details to the requesting clients.
Basically, I have created necessary stored procedures to pull out the data from the database. Now, I'm planning to have a data access layer called product (a class) which contains properties, enumerators etc., to load all the product details by executing the stored procedure. That is, the data access layer will be used by the business layer to deal with the product details in the means of populating it in the webpage, filtering etc.,
So, the product class inherits Collectionbase class to have all the enumerator, indexer funtionalities which is nothing but a custom data source and which can be used with DataGrid etc., and all the business logic like how to populate, what to populate has been written in the business layer (it uses the data layer to define the bl), which is eventually used by the web developers to design the dynamic pages of the site.
I'm having doubt whether this kind of approach will work best in web atmosphere rather than a windows application or not? and also loading 40,000 records in a collection base object will give better performance or not?
Please kindly suggest me, how to proceed in the terms of which is better way to deal with this.
Thanks in Advance Vadivel Kumar
And, I would like to know another one stuff like I'm developing a set of
libraries
which can be used with windows or web based interface my library code will
execute based on which kind
of interface it is deployed.
So, how to check this in C#, if you take C i normally use
preprocessor directive to check which platform, which architecture etc.,
based on that i will define my functions.
Kindly help me on this.
Thanks in Advance
Vadivel Kumar
"Vadivel Kumar" <do********@spam-i-love-u.com> wrote in message
news:uB**************@TK2MSFTNGP14.phx.gbl... Hi Guys,
I have a doubt which is little bit conceptual rather than a coding convention.
I have a a table called products in which I have 40000 and odd products which is expected to be frequently accessed by the website. I'm having doubt in how fast i can serve this product details to the requesting clients.
Basically, I have created necessary stored procedures to pull out the data from the database. Now, I'm planning to have a data access layer called product (a class) which contains properties, enumerators etc., to load all the product details by executing the stored procedure. That is, the data access layer will be used by the business layer to deal with the product details in the means of populating it in the webpage, filtering etc.,
So, the product class inherits Collectionbase class to have all the enumerator, indexer funtionalities which is nothing but a custom data source and which can be used with DataGrid etc., and all the business logic like how to populate, what to populate has been written in the business layer (it uses the data layer to define the bl), which is eventually used by the web developers to design the dynamic pages of the site.
I'm having doubt whether this kind of approach will work best in web atmosphere rather than a windows application or not? and also loading 40,000 records in a collection base object will give better performance or not?
Please kindly suggest me, how to proceed in the terms of which is better way to deal with this.
Thanks in Advance Vadivel Kumar This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: m. pollack |
last post by:
Hi all,
I've been using the CollectionBase class to implement a
strongly-typed collection, but I have noticed that the
RemoveAt method does not seem to call the "On" hook
methods (OnRemove,...
|
by: Eric Johannsen |
last post by:
I have a simple object that inherits from CollectionBase and overrides the
Count property:
namespace MyTest
{
public class CollTest : System.Collections.CollectionBase
{
public override int...
|
by: Samuel R. Neff |
last post by:
What's the advantage of inheriting from CollectionBase as opposed to
just implementing IList? It seems that it saves you from having to
implement a few properties (Clear, CopyTo, Count,...
|
by: Tom Jastrzebski |
last post by:
Hello,
I was just testing VB.Net on Framework.Net 2.0 performance when I run into
the this problem.
This trivial code attached below executed hundreds, if not thousand times
faster in VB 6.0...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
| |