Re: Re[2]: [PHP-WIN] MySql pconnect

> I have hard to see how this speed issues could be related to the > fact that MySQL does not provides you with stored procedures? > > In what way do you suggest to say that a SELECT statment or an allocation > of a connection would be slower just because the RDBMS provides you with > stored procedures? Please explain... I didn't mean to say that MySQL shouldn't provide stored procedures. If it doesn't hurt speed, I agree that it should allow such an option. Same with transactions. Furthermore I'd like more access restriction abilities, such as restricting the amount of requests/dataflow/connections a certain user can make over a given amount of time. What I meant to say was that I disagree that MySQL isn't a "good" RDBMS. However I agree it can and should be better than it is. But because it could be better does not mean it isn't "good" as it is. It may not be feature rich, but it's not missing features that majorly effect it's viability. The problem here is I believe we are using a different definition of quality. For me, something is "good" as long as it does what I want it to do. I have no current need for stored processes or transactions, so I wouldn't really care if it had it or not. From a link on that article I gave, about MySQL: "MySQL is a fundamentally different product from Postgres or InterBase, with different strengths and primary uses. It's a basic, stripped-down database that quickly serves up data to limited numbers of users. Its fast read performance, along with easy integration with Web scripting languages such as Perl and PHP, make it a favorite among Webmasters. MySQL is well suited to processing simple data on Web sites and a popular choice for building fairly low-traffic sites. The project recently moved from a rather constrained licensing scheme to the full GNU Public License (GPL) favored by many open-source projects, and has started to add elements of other existing software to address the feature gap it faces with PostgreSQL and InterBase." With exception to the fact I believe that MySQL is perfectly capable of supporting high-traffic sites, from that less-than-appealing description I still consider MySQL to be "good". If it does what I want it to, it's "good". But because MySQL apparently doesn't do what you want it to, I can see why you don't think it's so "good" ;) -- Plutarck Should be working on something... ...but forgot what it was. ""Svensson, B.A.T. "" <B.A.T.Svensson@lumc.nl> wrote in message news:27E647E5629ED211BF78009027289C630288B34E@mail1... > > >-----Original Message----- > >From: Plutarck [mailto:aemuli@spamclause-yahoo.com] > >Sent: Monday, April 16, 2001 8:53 AM > >To: php-windows@lists.php.net > >Subject: Re: Re[2]: [PHP-WIN] MySql pconnect > > > > > >As expressed in the article, the question is what the database > >was designed to actually "do". > > Well. Dear Plutark. The author are talking about a design of an INSTANCE > in the database in this case, not about the RDBMS it self - which I were > talking about. > > >MySQL creates quick connections, responds to SELECT statements as fast as > >anything can, has a small footprint, and does not require any special fees > >to use it. And yes, it's open source. For the vast majority of web sites, > >MySQL is an absolutely perfect fit. > > I have hard to see how this speed issues could be related to the > fact that MySQL does not provides you with stored procedures? > > In what way do you suggest to say that a SELECT statment or an allocation > of a connection would be slower just because the RDBMS provides you with > stored procedures? Please explain... > > >But if you are a bank or running a real-time game that requires player data > >to be saved constantly, for instance, something like Oracle is what you'll > >need (for now). > > You can use any RDBMS with sufficient functionality to do that "banking > thing". > It is "just" a matter of planning strategies for your design of your > database > system and the database schema of that database system. > > >But most people just don't _need_ transactions. However, MySQL is planning > >to add support for such things in later versions. You have to keep in mind > >that MySQL is new compared to Oracle. It makes sense that it has a smaller > >amount of features. > > Who did mention Oracle? I didn't.... My original statment was: > > "MySQL is even a worse RDBM's than I thought" > > Anyhow: If I want to run Formula-1, then I don't buy a Vas Lada, just > because > most people don't want to run fast. Just because "most people just don't > _need_ transactions", doesn't implies that MySQL is a good RDBMS! And that's > my > point! MySQL is not a suitable RDBMS system in general, and from that point > I made my conclusion stated above. > > >And on an unrelated issue, down with bloatware :) > > Excuse an ignorant person, but I didn't get that one? > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >