Hi,
What's the best way of storing a dataset (+/-1000 rows, 9 columns)?
I'm using a session-variable but this seems to have serious impact on
performance.
It's a shop and I'm using the same dataset (added an 'amount' cell) to
generate a dataview for basket
Most users will use the shop to order at 5pm (about 800 users), so I want to
keep server-stress within acceptable parameters.
Any help or suggestion is appreciated.
Thanks! 2 1473
Hi, Sjaakie Helderhorst,
First, if you will be keeping this information in the memory it will be the
same load if you keep it in the Session or in some other in-memory
object/collection because the information in terms of bytes is the same.
You can consider storing fewer details if the business logic allows it. i.e.
you can leave only the quantity and the id of each product. If it is
possible you will need 16 bytes for each record which makes
16*800(users)*1 000(products) which is approximately 12 MB.
Greetings
Martin
"Sjaakie Helderhorst" <di*********@ho tNOTmail.com> wrote in message
news:uY******** ******@TK2MSFTN GP12.phx.gbl... Hi, What's the best way of storing a dataset (+/-1000 rows, 9 columns)? I'm using a session-variable but this seems to have serious impact on performance. It's a shop and I'm using the same dataset (added an 'amount' cell) to generate a dataview for basket Most users will use the shop to order at 5pm (about 800 users), so I want
to keep server-stress within acceptable parameters.
Any help or suggestion is appreciated. Thanks!
Hello Martin,
Thanks for responding.
12MB seems acceptable to me. I'll give it a try.
Caching dataset on server and just storing UIDs on client-side.
I'm new to ASP.NET (familiar with ASP) so I'm having difficulties achieving
things that weren't any problem with 'old' ASP.
Guess it's just a matter of practice :)
Thanks again.
"Martin Dechev" <de*******@hotm ail.com> schreef in bericht
news:eL******** ********@TK2MSF TNGP12.phx.gbl. .. Hi, Sjaakie Helderhorst,
First, if you will be keeping this information in the memory it will be
the same load if you keep it in the Session or in some other in-memory object/collection because the information in terms of bytes is the same.
You can consider storing fewer details if the business logic allows it.
i.e. you can leave only the quantity and the id of each product. If it is possible you will need 16 bytes for each record which makes 16*800(users)*1 000(products) which is approximately 12 MB.
Greetings Martin "Sjaakie Helderhorst" <di*********@ho tNOTmail.com> wrote in message news:uY******** ******@TK2MSFTN GP12.phx.gbl... Hi, What's the best way of storing a dataset (+/-1000 rows, 9 columns)? I'm using a session-variable but this seems to have serious impact on performance. It's a shop and I'm using the same dataset (added an 'amount' cell) to generate a dataview for basket Most users will use the shop to order at 5pm (about 800 users), so I
want to keep server-stress within acceptable parameters.
Any help or suggestion is appreciated. Thanks!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Peter Foti |
last post by:
Simple question... which is better to use for defining font sizes and why?
px and em seem to be the leading candidates. I know what the general answer
is going to be, but I'm hoping to ultimately get some good real world
examples.
Fire away! :)
Regards,
Peter Foti
|
by: Ken Tucker |
last post by:
I've read about this issue in many articles across the net... But haven't
found a solution. I see all kinds of custom code to perform sorting with
datagrids, but my example is so simple, I must just be missing something.
Basically, I have a .aspx page that is very simple and has a simple
datagrid. All code is in the .cs page for the datagrid (hence, I'm doing all
datagrid work programmatically). The datagrid is populated from a SQL table...
|
by: David Hearn |
last post by:
I am trying to build a few pages basically emulating a wizard that you
might find in a Windows product. A few fields to fill out on one page,
move to the next, then the next. Finally, at the end, submit the data
from all the pages and save it all to a database or send it via email.
What is the best way to hold this data so that it there at the end for
posting to the database or email?
Thanks in advance!
|
by: Prince |
last post by:
I'm doing the following but I'm not sure if there is a
more efficient way to accomplish the same thing.
In my Page_Load() method, I accessed a database and
stored the information inside a DataSet. On my webpage,
I have a DataList server control that binds to the
DataSet. The method looks something like the following:
Page_Load(){
//do the database connection plus binding
|
by: Anonieko Ramos |
last post by:
ASP.NET Forms Authentication Best Practices
Dr. Dobb's Journal February 2004
Protecting user information is critical
By Douglas Reilly
Douglas is the author of Designing Microsoft ASP.NET Applications and
owner of Access Microsystems. Doug can be reached at
doug@accessmicrosystems.com.
--------------------------------------------------------------------------------
| |
by: Yul |
last post by:
Hi,
We are in the process of designing an ASP.NET app, where a user will
enter some 'Customer ID' to be queried in the database. If the ID is
valid, several stored procedures will be called to populate multiple
webpages containing customer information. There isn't a one-to-one
correlation between the stored procedure and a webpage. In other
words, a webpage may have to refer to 1 or more DataTables to populate
itself. Therefore, a...
|
by: Dave |
last post by:
(My apologies for posting this on two forums. I have just found out the other
one was the incorrect location)
I am writing a VB.NET 2003 web application to operate on my company's
intranet. It accesses data in an SQL Server database. I have developed a
couple of pages that display data successfully. However, there is one area
that I am having trouble getting a handle on, despite purchasing a couple of
Wrox books.
Up until now, I have...
|
by: masmith |
last post by:
What is the best method to get data from the database once and use it on
several pages of a web site?
In ASP.NET 1.1 I would populate a Dataset in the Global.asax and save it to
a Session or Application variable. I would then use that Dataset for drop
down lists used on various web pages. This would limit hits against the
database server for data that almost never changes. If it did change I could
force the session or application to...
|
by: Ned Balzer |
last post by:
Hi all,
I am pretty new to asp.net; I've done lots of classic asp, but am just
beginning to get my mind wrapped around .net.
What I'd like to do is include some code that tests if a user is logged
in, on each and every page, and redirects the user to a login page if
s/he's not logged in. The login page will also take care of some
standard setup, such as choosing/populating a user profile. I used to
use <!-- #include ... --for this,...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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.
| |