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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.