* Carlos J Souza > Mysql 5.x is more quick than 4.x ? This may seem like an easy question, but it is not.
I suppose you know the current stable version is 4.0.x, version 5.x is a development version in an 'alpha' state. I have not tried version 5 myself, and I am not one of the developers. This is based on my assumptions only. If we were talking about the max speed of two cars, it would be easy, but a database server is nothing like a car. There are many different "speeds" within a server, and there are even some "speeds" _outside_ the server... I'll try to explain. The first thing that comes to mind when you ask about database speed, is the speed of retrieval of data, or the speed of SELECT statements. If no index is involved, I would expect the speed to be about the same for both versions. If indexes are used, I would expect version 5 to handle a few cases better than version 4, but for most cases I would expect the same speed. I expect sub-selects to be even more powerfull in 5.x compared to 4.x, making it possible to eliminate a lot of programatically looped queries, resulting in faster applications. You would also want to make changes to you database, using INSERT, UPDATE and DELETE statements. You may want to use transactions. I would expect more constraints in version 5, making most updates slower compared to a system with less constraint checking. This is however a tradeoff you sometimes want, because of the benefits of the constraints, see below. Transactions are supported in both versions, but I would expect the features of a future stable version 5 to be more optimized, thus faster. However a non-transactional table is usually faster, both versions and even version 3 supports non-transactional tables. Version 5 will have cursor support, making some application types easier to implement, and probably speed up some applications needing this feature. Memory based tables (HEAP) will be improved in version 5. Put together with the low prices on RAM I would expect more RAM based superfast version 5 databases. The Stored Procedures feature of version 5 will, together with improved constraint checking, make it possible to create the same kind of advanced database software on a MySQL platform as we today can do on high-end commercial systems (SP, triggers, constraints). The major difference is that we can move the "business rules" or the application logic from the often distributed application layer to the usually centralized database layer. This will make it possible to develop large systems within large organizations safer and faster, and this is an example of how different versions of a database server can have different "speeds" outside the server: the speed of developing/maintaining the database. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
