SLOW VIEW
Hi,
my name is Niccolò Benvenuti, from Italy.( I'm sorry for my English!).
My problem:
I distrubute an ERP software for small industry (5 to 50 connection/clients). This software can use Sqlserver or Mysql.
I prefere to install mysql. The problems are the views!
There are same views constructed in this mode:
(select ....... ) union all ( select .......) union all ( select ... )
I convert a database from sqlserver 2008R2 to mysql5.5 and run the same view.
The time of mysql is ten time bed and more!!
Time of sqlserver ( 180.000 rows ) il 3 seconds, mysql ( the same tables ) is 120 seconds.
Do you think that the problem could be the tuning of mysql ?
The others select have the same time between slqserver and mysql....
Thank to all!!
Niccolò
Subject
Written By
Posted
SLOW VIEW
June 19, 2012 03:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.