Re: Hardware and Performance

[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        |_| \_\