I have written a query to create a view which i can use as a flat table in my application, which is having more than 30 inner join conditions across 25 tables. Now the problem is every time i am selecting the view with even 2-3 columns without adding any further condition or clause, it is taking more that 45-50 seconds to load.
No of records in the view : around 250
No of Columns in view : 45-50
My.cnf seems okay, i have checked it using mysqltuner perl script. I have tweaked the relevant parameters in my.cnf , but no significant effect noticed in query response time.
Engine Type : InnoDB, Foreign key constraints applied.
Mysql version : Percona mysql 5.6
Thanks in Advance.