Re: Hardware and Performance

["Colin Mitchell" <colin@5points.net>]

There is a lot of overhead involved in establishing the connection between
the SQL server and minivend.  Sockets need to be opened, etc.  In my
network, we have a box dedicated to running mySQL, so minivend needs to
establish a TCP connection to the server, which takes even longer than when
they are on the same machine.

Anyway, I think Allan's point is this - a lot of programs keep a persistient
connection open to the SQL server.  This way, that connection overhead isn't
a problem.  It's not particularly impossible to setup.  Essentially, you
keep a pool of already opened connections to the server, and you use those
whenever possible instead of opening a new one.

Apologies if this was obvious or if I missed the point - Colin


> Date: Mon, 14 Jun 1999 18:49:34 -0400
> From: mikeh@minivend.com
> Subject: Re: Hardware and Performance
>
> ******    message to minivend-users from mikeh@minivend.com     ******
>
> Quoting allan deleon (allan@instantsoft.com):
> >
> >
> > We're serving 380 dynamic minivend templates (over 90% of these
> > templates access an sql database using [sql set/list, etc.] ) on a Sun
> > Enterprise 450 with 4 ultra sparc CPUs and 1 gig of memory and
> > 18 gigs of ultra wide scsi.
> >
> > But even with this machine, I worry about minivend's lack of a
> > database connection pool. It simply will not scale if it has to open
> > a database connection for every database access in a catalog.
> >
>
> It is not for every access, it is once for every web transaction and
> only if that database is referenced.
>
> I still have never seen any numbers on this. Aren't the database
> servers themselves caching table opens? If so, why not?
>
> There is a new global database capability in 3.14, so heavily used
> common tables can stay open, but I can't understand why I should keep
> connections open when there can be thousands of tables. If anyone
> can explain the sense of this, I am all ears.
>
> - --
> Mike Heins                          http://www.minivend.com/  ___
>                                     Internet Robotics        |_ _|____
> In character, in manners, in        131 Willow Lane, Floor 2  | ||  _ \
> style, in all things, the           Oxford, OH  45056         | || |_) |
> supreme excellence is               <mikeh@minivend.com>     |___|  _ <
> simplicity. -- Longfellow           513.523.7621 FAX 7501        |_| \_\
> - -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to
> Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
>



[] "I promise I shall never give up, and that I'll die yelling and   []
[] laughing.  And that until then I'll rush around this world I      []
[] insist is holy and pull at everyone's lapel and make them confess []
[] to me and to all." - Jack Kerouac                                 []