3 ms·
It's great in theory, but in most databases I've used, if you get too crazy with views your performance goes to crap. The optimizer just can't handle it. Views
by ams6110 8y ago
It's great in theory, but in most databases I've used, if you get too crazy with views your performance goes to crap. The optimizer just can't handle it.
Views are great for specific use cases, but if your interaction with the underlying tables is entirely through views I've never had that work really well.
- garmaine 8y agoChicken and egg problem. It's inefficient because no one does it, not because of fundamental computer science problems. If Active Record et al adopted it, I guarantee you database vendors would make it efficient.
- ako 8y agoI used this approach, views on top of tables for all data access, quite often on oracle 7,8 & 9. Oracle query optimizer can handle it perfectly fine.