Hello,
So I have converted a database from MSSQL to MySQL and for the most part it's all good. The big issue I'm having is with the performance with using views in MySQL(5.0.45). The query I run in MSSQL returns in 1 second and in MySQL it takes 1 and a half hours. Now I did not expect it to be as fast a MSSQL but not that slow.
Any suggestions?
Thanks,
tom