Home Posts Topics Members FAQ
Greg Collins [InfoPath MVP]
I'm designing a series of ASPX pages (actually one page with a series of parameters) which call a SQL SPROC to update a visit count.
This is great right now because the pages are not visited very much. I anticipate eventually having a large flow of traffic through these pages. My worry is that if I eventually have 100,000+ visiters to these pages per day, I'm going to overload SQL by calling the SPROC per visit per page to perform an increment to the visit count.
I thought of a solution, and I'm seeking either clarification that this is a good idea, or alternate ideas from those who've been there. My idea is this:
Have each page update a hashed value in a Application variable. Every five minutes or so, have the Application visit counts would be sent to the SPROC for a single update, and would pull back down the counts for the top-10 list being built.
It seems to me like this would save a lot of traffic and wear-and-tear on the SQL database. Am I headed the right direction, or is there something better I should be looking at?
Thanx!
--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com
Nov 19 '05 #1
Subscribe Reply
1 971
Bruce Barker
your approach is ok. but 100K visits a day is not very high, the sqlserver
should handle the load fine.
-- bruce (sqlwork.com)
"Greg Collins [InfoPath MVP]" <Greg.Collins_A T_InfoPathDev.c om> wrote in
message news:OT******** ******@TK2MSFTN GP12.phx.gbl...
I'm designing a series of ASPX pages (actually one page with a series of
parameters) which call a SQL SPROC to update a visit count.
This is great right now because the pages are not visited very much. I
anticipate eventually having a large flow of traffic through these pages. My
worry is that if I eventually have 100,000+ visiters to these pages per day,
I'm going to overload SQL by calling the SPROC per visit per page to perform
an increment to the visit count.
I thought of a solution, and I'm seeking either clarification that this is a
good idea, or alternate ideas from those who've been there. My idea is this:
Have each page update a hashed value in a Application variable. Every five
minutes or so, have the Application visit counts would be sent to the SPROC
for a single update, and would pull back down the counts for the top-10 list
being built.
It seems to me like this would save a lot of traffic and wear-and-tear on
the SQL database. Am I headed the right direction, or is there something
better I should be looking at?
Thanx!
--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com
Nov 19 '05 #2
This thread has been closed and replies have been disabled. Please start a new discussion.
Similar topics
18 6671 Preventing memory fragmentation by: Tron Thomas |last post by: Given the following information about memory management in C++: ----- The c-runtime dynamic memory manager (and most other commercial memory managers) has issues with fragmentation similar to a hard drive file system. Over time, the more often use call new/delete or alloc/free, there will be gaps and fragments in the heap. This can lead to inefficient use of available memory, as well as cache-hit inefficiencies. C / C++ |
1 2063 Error with overload of >> and << but not only :-((((( by: Piotre Ugrumov |last post by: I'm following your help. I have written the overload of the operator <<. This overload work! :-) But I have some problem with the overload of the operator >>. I have written the overload of this least operator for the class Person, but I don't know how write the overload for a class that derived from the class Person. The overload of << in Person is this: ostream & operator<<(ostream &out, const Persona &p){ out<<p.getNome()<<"... C / C++ |
1 2517 preventing multiple logins by: Sameer |last post by: one important problem i am facing is that my web solution (asp.net) will be deployed on a webfarm. I am using sql server session management on clustered sqlservers. but as i need to prevent multiple logins through a username/password (same credentials at a time) on the website. also session_end() event does not fire in sql server mode. one solution is sychronized cache of webservers. and C# / C Sharp |
1 2211 preventing carriage return from causing postback by: Steve |last post by: I have a simple form with a textbox and a command button, both web form controls (not raw HTML controls). I notice that when the user enters text in the textbox and hits carriage return, the form posts back. Is there a way to prevent this? I think it is undesirable for two reasons 1) Developer must support re-rendering the page even if no events fire, which is another path through the code to worry about (not always trivial if... ASP.NET |
2 1948 Preventing User from backing up to previous page? by: Brian Mitchell |last post by: I want to implement a logoff feature in my ASP.NET application (using VB), but how do I expire or delete the pages from the cache so another user can't simply use the back arrow to bring the pages back up? Thanks!! ASP.NET |
3 2124 HttpModule preventing execution of HttpHandlers by: MWells |last post by: I'm having an issue getting my HttpHandlers and HttpModules to play together nicely. My HttpHandlers take special document types (defined by extension) and process them specially. I might have an HttpHandler installed to render Excel files as HTML, or to render TIFFs to JPEGs, etc. The HttpModules are used for Uri handling, so that a request for a resource like; ASP.NET |
3 5758 PHP sessions - user login webpage - preventing autologout due to inactivity by: Dave Smithz |last post by: Hi there, I have a website where users can log into. This users sessions as I believe most people use when implementing a login section of a website (each php page first checks a valid parameter has been set to authorise that the user has logged in and if it is not found it redirects the user to the login page). I have my code and it works fine, however on the live server, after a period of inactivity the user will be logged out... PHP |
20 5640 Preventing italics text from hitting the next character by: Jukka K. Korpela |last post by: I recently noticed, once again, how the common implementation of italics can really disturb. I'm referring to the common phenomenon that there is by default too little spacing after italics text, so that if you have, say, <em>Bill</emWatterson then the last "l" of "Bill" hits the "W" - they may even slighly overlap. I noticed this long ago, and I discuss it briefly at http://www.cs.tut.fi/~jkorpela/math/#it in the context of mathematical... HTML / CSS |
5 3695 Overload lookup of pointer-to-member by: jknupp |last post by: In the following program, if the call to bar does not specify the type as <int>, gcc gives the error "no matching function for call to bar(A&, <unresolved overloaded function type>)". Since bar explicitly takes a pointer-to-member with no parameters, why is the lookup for the overloaded function not able to use the number of arguments to determine the appropriate function? Is there a relevant portion of the standard that governs the... C / C++ |
8668
What is ONU? 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, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look ! Part I. Meaning of... General |
9152
Problem With Comparison Operator <=> in G++ 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... C / C++ |
1 8885 The easy way to turn off automatic updates for Windows 10/11 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,... Windows Server |
8855
Discussion: How does Zigbee compare with other wireless protocols in smart home applications? 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... General |
7708
AI Job Threat for Devs 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 projectplanning, coding, testing, and deploymentwithout 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... Career Advice |
4358 Trying to create a lan-to-lan vpn between two differents networks 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... Networking - Hardware / Configuration |
1 3037 transfer the data from one system to another through ip address 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 C# / C Sharp |
2 2320
How to add payments to a PHP MySQL app. by: muto222 |last post by: How can i add a mobile payment intergratation into php mysql website. PHP |
3 1995
Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy 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 effective websites that not only look great but also perform exceptionally well. In this comprehensive... General |
By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.
To disable or enable advertisem*nts and analytics tracking please visit the page.