p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

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,

{{

{{


  Return to Index