Need to optimise performance of a database view using indexes
Budget: ₹750 – ₹1,250 INR
I have a mysql view that is derived by union of three different set of tables. Currently querying the view takes around 10 seconds which is slowing down the system.
I am looking for database expert who can help me otimize the performance of the view. either by using idexes or any other way possible.
I also need a databse trigger that will populate a table based on changes to this view. - this will be a separate job which we can do after improving the performance. Attached view for your reference.
I have databse hosted on cloud. Wil give you both database dump and access to cloud database whichever is required
I am looking for database expert who can help me otimize the performance of the view. either by using idexes or any other way possible.
I also need a databse trigger that will populate a table based on changes to this view. - this will be a separate job which we can do after improving the performance. Attached view for your reference.
I have databse hosted on cloud. Wil give you both database dump and access to cloud database whichever is required