quote:

---

The main new features of MySQL version 4.0 are geared toward enhancing the MySQL database software as the solution for mission-critical, heavy-load database systems and to optimize performance as an embedded database. MySQL version 4.0 includes:

• A query cache, offering increased performance for many applications with repetitive queries
  
• Full-text indexing, searching on packed indexes, bulk inserts and other new optimizations for faster query execution


• An embedded MySQL server library, making the MySQL database faster and easier as an embedded database in other applications
  
• The transactional engine, InnoDB, in the standard 4.0 binaries, adding transactions, row-level locking, and foreign key integrity
  
• Features to simplify migration from other databases to MySQL, such as the “Truncate Table,” “Union” and “Cast” SQL syntax additions

More detailed information about new features in MySQL version 4.0 can be found at the MySQL AB Web site at www.mysql.com/doc/en/Nutshell_4.0_features.html." target="_blank">http://www.mysql.com/doc/en/Nutshell_4.0_features.html.

"MySQL version 4.0 provides a rich array of new features, including the impressive new query cache feature and the InnoDB transactional engine," said Anthony Boyd, manager of Web Technology at Silicon Storage Technology, Inc., a major flash memory provider based in Sunnyvale, California. "In addition to several stand-out and ease-of-use improvements, we have found the upgrade to MySQL version 4.0 from version 3.23 to be an easy one."

---

quote:

---

Woo Hoo! But no stored procedures yet?

---