The features I am most excited about are:
* Greatly improved full text indexing support. MySQL now has fairly decent full text indexes (which means really fast searches on large amounts of text). It's still not as good as MS SQL's, but it's pretty nice. The indexer in 3.23 was awful.
* Query caching - MySQL now has a built in query cache so if you send it the same SQL query twice, and your tables hasn't changed, it pulls the results from a cache rather then redoing the query. Can result in dramatic performance gains.
If you are into "real" database features, the Innodb table type is greatly improved as well (provides transactions, row-level locking and foreign key support).
For a full list, see http://www.mysql.com/doc/en/News-4.0.x.html.
Cheers,
Alex
--
Gossamer Threads Inc.
* Greatly improved full text indexing support. MySQL now has fairly decent full text indexes (which means really fast searches on large amounts of text). It's still not as good as MS SQL's, but it's pretty nice. The indexer in 3.23 was awful.
* Query caching - MySQL now has a built in query cache so if you send it the same SQL query twice, and your tables hasn't changed, it pulls the results from a cache rather then redoing the query. Can result in dramatic performance gains.
If you are into "real" database features, the Innodb table type is greatly improved as well (provides transactions, row-level locking and foreign key support).
For a full list, see http://www.mysql.com/doc/en/News-4.0.x.html.
Cheers,
Alex
--
Gossamer Threads Inc.
