--- Andrew Piskorski <[EMAIL PROTECTED]> wrote: > > How does that follow at all? What difference does > it make that your > servers are SMP machines with multiple processors? > AOLserver runs > quite nicely on SMPs, regardless of what database > drivers it uses. I > am not aware of any performance reasons to prefer an > external over an > internal driver, are you?
Well, like I said- I'm new to AOLServer so I'm going off of the tuning docs: http://www.aolserver.com/docs/admin/dbadmin.html Speaking of external drivers: "It is likely, however, that this distributed approach, i.e. a separate process per database connection, will improve overall database throughput, even with the additional communication overhead. We expect this performance improvement because vendor-supplied database client libraries, running within a multi-threaded server, must limit concurrency via resource locks." I'm using FreeBSD as my OS, and it's got several threading models. The "sane" one will not distribute threads to different CPUs (eliminating any gain from SMP). The 1-1 thread-proc model and the KSE model are both new to 5.x, which I'm a little hesitant to use... So- if I end up going with stable-FreeBSD, all SMP value will be lost unless I can break the DB stuff in to different procs (vs different threads). And the way to do that is through external drivers :) > Both the Oracle and PostgreSQL drivers are internal > (same process > space as AOLserver), and those are the only ones I'm > familiar with. > AOL folks, you actually use Sybase via an external > driver at AOL, > right? Could you comment on this? > > Why FireBird? Are you using it extensively for > other (non-AOLserver) > applications? Is anyone else out there using it > much? For what would > it be better than PostgreSQL, and how? I ask > seriously, as I'm kind > of curious about all those things, but have never > attempted to keep > track of what the Firebird RDBMS folks are up to. My experience with either is limited and they *are* pretty feature-comparable, but the specific advantages that made me choose Firebird over Postgresql are these: Shadow-db functionality. SPs without linked-in-interpreters. (less code to have to trust) Simpler administration. (for me anyway) And well- it just leaves a little more "robust" of a taste in my mouth, Interbase is likely the largest-deployed-db on the planet. But- like I said, the differences between both are minor, so if I had to use Postgresql, I could. ===== -- live- http://www.thedenofsin.org/ to- AIM: IMFDUP _-jupiter accepts your offer-_ -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
