Research application running a mysql database, which include a table of 1.5 million lines x 1000 columns needs a review for optimizing the run time of teh daily updates script.
Consider it done.... I will help you achieve results above and beyond you expectation with a quick turnaround...Hope to achieve next positive feedback from you!!! Please check you inbox for more info.
I have extensive experience in the theoretical and practical aspects of optimizing SQL queries and database structures as well as performance tuning of MySQL server environments. I have my own infrastructure for performance analysis on test data samples.