Hello Gordon, > And now we are down to reality. This is a MySQL list. Views are a wonderful > thing for creating an isolation layer between the application and the > database. However, MySQL's current implementation makes it extremely > difficult in many cases to avoid full table scans when you define the > logical view. {Not poking at the development team I think 5.x is a huge step > forward}.
Can you elaborate on that? Any real world experience with MySQL views? The thing that annoys the blo*** cr** out of me with the current implementation is the maintainability of views -> as the complete query structure is lost once you've created a view, so you need to run/modify it from SQL statement all the time :-( Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]