An extremely fast database is a key comonpent to a successful SugarCRM implementation. MySQL lead architect Brian Aker has announced the Drizzle project which will redesign the MySQL core to be based on a modular architecture. The upside of this redesign will be the ability to install a MySQL-based db without unneeded functionality that slows down the db engine. Hence a smaller db engine designed for Web-based apps.
Some of the functionality that won’t be in the core engine are listed in the project FAQ.
No modes, views, triggers, prepared statements, stored procedures, query cache, data conversion inserts, ACL. Fewer data types. Less engines, less code. Assume the primary engine is transactional.
It appears Drizzle is a separate project and product with many MySQL engineers working on it but not being directly run by Sun/MySQL. It would be interesting to see how much of this work will factor back into the core MySQL distribution over time. Either way, it seems there is certainly a market for lean and mean db’s targeted exclusively at Web-based apps.