Hi:
I have a Point-of-sale application that uses SQL Server2000 for the backend.
Basically, the users perform various functions boiling down to login (check
password from a table) and data entry (insert a food entry). Previously, I
would open a new ADO 2.7 connection to the database each time one of these
types of database accessing functions needed to be performed - but I noticed
that sometimes the DB would freeze the application for 20 seconds or so - or
even cause a timeout error.
To fix this, I open a DB connection when the application first starts,
keeping it open for the life of the application - each time a function needs
to access the DB, it just uses the applications (global) connection that is
constantly open and connected.
This seems to have fixed the problem, however, I am curious, is this an OK
way to handle the connections - keeping in mind that there are four separate
stations - each running the application - at the same time. Therefore, I
have 4 constantly open connections at the same time.
Thanks and regards,
Ryan Kennedy
2  2043 
"Ryan P. Kennedy" <ry***********@ verizon.net> wrote in message
news:lY******** *********@nwrdn y01.gnilink.net ... Hi:
I have a Point-of-sale application that uses SQL Server2000 for the
backend. Basically, the users perform various functions boiling down to login
(check password from a table) and data entry (insert a food entry). Previously,
I would open a new ADO 2.7 connection to the database each time one of these
types of database accessing functions needed to be performed - but I
noticed that sometimes the DB would freeze the application for 20 seconds or so -
or even cause a timeout error.
To fix this, I open a DB connection when the application first starts,
keeping it open for the life of the application - each time a function
needs to access the DB, it just uses the applications (global) connection that
is constantly open and connected.
This seems to have fixed the problem, however, I am curious, is this an OK
way to handle the connections - keeping in mind that there are four
separate stations - each running the application - at the same time. Therefore, I
have 4 constantly open connections at the same time.
Thanks and regards,
Ryan Kennedy
I don't know much about ADO, but it sounds like you're describing a form of
connection pooling, which is certainly a very common way to manage
connections from multiple clients.
Simon
"Ryan P. Kennedy" <ry***********@ verizon.net> wrote in message
news:lY******** *********@nwrdn y01.gnilink.net ... Hi:
I have a Point-of-sale application that uses SQL Server2000 for the
backend. Basically, the users perform various functions boiling down to login
(check password from a table) and data entry (insert a food entry). Previously,
I would open a new ADO 2.7 connection to the database each time one of these
types of database accessing functions needed to be performed - but I
noticed that sometimes the DB would freeze the application for 20 seconds or so -
or even cause a timeout error.
To fix this, I open a DB connection when the application first starts,
keeping it open for the life of the application - each time a function
needs to access the DB, it just uses the applications (global) connection that
is constantly open and connected.
This seems to have fixed the problem, however, I am curious, is this an OK
way to handle the connections - keeping in mind that there are four
separate stations - each running the application - at the same time. Therefore, I
have 4 constantly open connections at the same time.
Connection pooling, the sharing of a single connection among components of
an application, is very common and a good design principle. It is
particularly great for web based/ASP applications, in order to conserve
resource. Persistant connections, keeping a connection open even when not in
use, is something I shy away from in my client server and my web based app
designs. I prefer to create a connection, pool it, and then open and close
it as needed.
It sounds like you are looking for a solution to a symptom, and not your
problem. If I were you, I would investigate the reason your app is timing
out and solve that.
--
BV.
WebPorgmaster - www.IHeartMyPond.com
Work at Home, Save the Environment - www.amothersdream.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Tumurbaatar S. |
last post by:
Is it so important to close database connections?
As I understand, after processing a request and sending a response,
page object destroyed. So all used connections also destroyed.
Yes?
|
by: Chris Love |
last post by:
I have already asked this, but no one seems to know the answer. Here is the
timeline. I wanted to use the membership/roles functionality in a site. I
got all sorts of errors trying to get this setup on the site through the
admin interface.
So I yanked it out of the application since it did not work. Now everytime
I load the site after changing the application I get this error message. If
I simply refresh the page, everything works...
|
by: JoeSep |
last post by:
Hi!
Is it correct/safe to define a connection pool in the string
"sqlConnectionString" of the "sessionState" section of Web.config?
- The application is developed using AspNet 1.1 in a Windows Server 2003.
- The AspState DB is defined in a Sql Server 2000 DB on another server.
I have added this definition to the Web.config file:
<sessionState
mode="SQLServer"
|
by: ricolee99 |
last post by:
Hi Everyone,
Thanks for reading my post. Can someone please tell me if there's
something in .net framework that will allow me to determine the name of
the default internet connection? I have two types of connections: LAN
and dial up (3 different ISPs), I would like to determine what the user
has for default connection.
Thanks in advance
|
by: eboschi |
last post by:
Hi all, i'm new to .net programming and i have some problems with database connection. I have written two web application. Both of them use ADODB Connection to Sql Server 2000 database. The problem is in second one.
The first application is used for order management. I have defined in Main.aspx page a variable called localSqlConnection. Every time i enter this page (only one time per session) i create connection to local database and then i...
| | |
by: John |
last post by:
Hi
I have a windows form app with one master table and several details (grids).
As I am filling both the master and details using vs 2005 generated dataset
and data adapters, there are multiple connection open/close during the whole
operation (one connection open/close per adapter fill). Is there a way to
override the vs generated connection management code to open the connection
only once at start, do all fills and then close the...
|
by: =?Utf-8?B?Sm9obkJhdGVz?= |
last post by:
I'm trying to (programatically) backup and clear the security event log on
the local machine. I can do this manually through the event viewer and I am
logged on as an administrator. I can successfully connect to the local wmi
service. I can step through and list all the log files on the local computer
in a text box so I know I can get an System.Management.ManagementObject that
is the security log.
However when I try to execute the...
|
by: TG |
last post by:
Hi!
Once again I have hit a brick wall here. I have a combobox in which
the user types the server name and then clicks on button 'CONNECT' to
populate the next combobox which contains all the databases in that
server. Then after the user selects a database, I have another button
that he/she click and I want to retrieve file groups from a specific
table. At this point when he/she clicks on that button I get an
error:
|
by: TG |
last post by:
Hi!
Once again I have hit a brick wall here. I have a combobox in which
the user types the server name and then clicks on button 'CONNECT' to
populate the next combobox which contains all the databases in that
server. Then after the user selects a database, I have another button
that he/she click and I want to retrieve file groups from a specific
table. At this point when he/she clicks on that button I get an error:
|
by: Johnson |
last post by:
I'm trying to fix a "sub optimal" situation with respect to connection
string management. Your thoughtful responses will be appreciated.
I just started with a new client who has a bunch of legacy ASP.NET
applications that all manage connection strings in Web.config the same way,
like this:
This client has one Web.config file per application, and that one Web.config
file is duplicated across all environments (i.e., dev machines, test,...
|
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...
| | |
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: 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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
