Metalzed Posted September 24, 2010 Share Posted September 24, 2010 Hi. Lets say that you have a very advance query you like to preform. eg. In the query there is 7 tables with Join. 5 Sub-SELECT querys Would you split it up and doing views. Lets say 3 diffrent Views and then you can use one Query with 3 joins and 1 Sub-Select It is a lot easier to find error when you split it up. Also to do changes. But Is it a lot slower? Is there any other reason not to do it? Link to comment https://forums.phpfreaks.com/topic/214320-using-views-better-than-a-advance-query/ Share on other sites More sharing options...
fenway Posted September 25, 2010 Share Posted September 25, 2010 There are no materialized views in mysql, so it's basically the same. Link to comment https://forums.phpfreaks.com/topic/214320-using-views-better-than-a-advance-query/#findComment-1115613 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.