RE: [PHP] DB stuff

Do you honestly believe that database load-balancing should be done at the scripting language level? Use a database that provides this functionality if this is what you need. -Rasmus On Tue, 7 Nov 2000, Voitenko, Denis wrote: > I agree with you on most points. I myself use custom DB abstraction. Now try > putting 300 users on your MySQL database. What happens? Even an SMP box > starts begging for forgiveness. How would your prioritize your queries, put > them in a queue or load balance a couple of database servers? > > > > > -----Original Message----- > From: Michael Kimsal [mailto:michael@tapinternet.com] > Sent: Tuesday, November 07, 2000 8:27 AM > To: Voitenko, Denis > Cc: 'php-general@lists.php.net' > Subject: Re: [PHP] DB stuff > > > You're stirring up a hornet's nest here... :) Go read the archives > (link to archive sites are found on php.net under 'support' I think). > > Couple things to keep in mind here - first off, PHP isn't an application > server - it's a scripting language. This isn't a putdown of PHP, but you > gotta > remember that PHP was doing stuff before many of the people at > these larger companies had even heard of the internet. > > Second, there are abstraction layers that you can use in PHP to > give that you independance. It's at a (slight?) speed decrease. By > coding using native drivers and coding for the specific database, > you can (so the story goes) get more performance out of the application. > That's been my experience as well. > > This isn't meant to flame people working on DB abstraction stuff (we've > done our own in house as well, which also support query results caching) > but honestly, how many times do you switch databases in the middle of a > project? If you've spent how many thousands on weblogic, do you > change DBs in midstream that often? > > If you've gotta configure things in the 'guts' on weblogic, I can do pretty > much the same thing by changing about 3 lines in an include file. > > > > "Voitenko, Denis" wrote: > > > I am wondering why wouldn't PHP support database connectivity like most > > application servers do, e.g. something like a data source in JRun or > > WebLogic where database connectivity is made DB server independent and all > > the DB connectivity is configured in the guts of PHP? > > -- > ========================== > Michael Kimsal > http://www.tapinternet.com > 734-480-9961 > >