|
 |
asp_databases thread: Managing no of connections.
Message #1 by Hari Yellina <hyellina@k...> on Wed, 26 Jul 2000 05:51:51 -0500
|
|
Dear All,
If 10000 users are accessing my database. My speed will be reduced. How to
make my page become fast. When is the methodology when 10000 users are
connected to database.
HK Yellina,
Kanbay Software (India) Pvt. Ltd.
A-1, Technology Park,
MIDC,
Talwade,
Pune,
Maharastra.
412114
ph 091-020-7691100 ext-440
Message #2 by "Ken Schaefer" <ken.s@a...> on Thu, 27 Jul 2000 10:45:49 +1000
|
|
I find that telling 9999 of the users to stop visiting the website makes it
run much faster the for the remaining user...
Cheers
Ken
----- Original Message -----
From: "Hari Yellina"
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, July 26, 2000 8:51 PM
Subject: [asp_databases] Managing no of connections.
> Dear All,
>
> If 10000 users are accessing my database. My speed will be reduced. How
to
> make my page become fast. When is the methodology when 10000 users are
> connected to database.
> HK Yellina,
Message #3 by "Fredrik Normen" <fredrik.normen@s...> on Thu, 27 Jul 2000 8:35:39
|
|
There are many things to do.
First of all try not to use ADO in the ASP page.
Make a COM components that maintain the data, and put it in the MTS och
Component Services for using thread and connection pooling and onother good
feature.
Because of the connection pooling or (session pooling "OLE DB" )
you will reduce the amount of connection to the database.
Connecton pooling work like this:
When a user open a connection it will be pu into a pool of connections.
When the user close the connection, it will still be left in the pool.
But when a new user want to open a connection it can use the connection
thar are in the pool.
Try to open the connection before you want to use the database and close it
as soon as possible. Don't put the connection or any object in a session or
application variable it will make IIS running in single threaded mode and
will reduce the performance.
There are many things to be aware of, but It will take time to write all of
that down.
/Fredrik Normen
Message #4 by "Dana Coffey" <dcoffey@x...> on Thu, 27 Jul 2000 08:54:35 -0400
|
|
hee hee
Ken, what was in your fruity pebbles this morning?
=o)
Dana Coffey
Technologist, Xceed, Inc.
112 Krog St. Atlanta, GA 30307
tel. xxx-xxx-xxxx x 5013
dcoffey@x...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Everything should be as simple as it is, but not simpler.
----Albert Einstein
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
{{-----Original Message-----
{{From: Ken Schaefer
{{Sent: Wednesday, July 26, 2000 8:46 PM
{{To: ASP Databases
{{Subject: [asp_databases] Re: Managing no of connections.
{{
{{
{{I find that telling 9999 of the users to stop visiting the
{{website makes it
{{run much faster the for the remaining user...
{{
{{Cheers
{{Ken
{{
{{----- Original Message -----
{{From: "Hari Yellina"
{{To: "ASP Databases" <asp_databases@p...>
{{Sent: Wednesday, July 26, 2000 8:51 PM
{{Subject: [asp_databases] Managing no of connections.
{{
{{
{{> Dear All,
{{>
{{> If 10000 users are accessing my database. My speed will be reduced. How
{{to
{{> make my page become fast. When is the methodology when 10000 users are
{{> connected to database.
{{> HK Yellina,
{{
{{
|
|
|
View Cart
