Preventing overload of SQL hits | Bytes (2024)

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 Preventing overload of SQL hits | Bytes (1) 971 Preventing overload of SQL hits | Bytes (2)

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, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s 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 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...

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.

Preventing overload of SQL hits | Bytes (2024)
Top Articles
Latest Posts
Article information

Author: Dan Stracke

Last Updated:

Views: 6296

Rating: 4.2 / 5 (63 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Dan Stracke

Birthday: 1992-08-25

Address: 2253 Brown Springs, East Alla, OH 38634-0309

Phone: +398735162064

Job: Investor Government Associate

Hobby: Shopping, LARPing, Scrapbooking, Surfing, Slacklining, Dance, Glassblowing

Introduction: My name is Dan Stracke, I am a homely, gleaming, glamorous, inquisitive, homely, gorgeous, light person who loves writing and wants to share my knowledge and understanding with you.