[SOLVED][3.1] Dropdown SQL Performance
Posted: Mon Oct 17, 2016 8:26 am
Hello,
I installed a new server with 3.1 on CentOS Linux (Stack 205)
My previous version was 3.0 on Windows Server 2012.
I all work fine except when I use a combo which other fields depend on, I get a noticeable loss in performance comparing to previous server.
In this example I have 3 Fields and 1 Dropdown.
On PM3.0 (Windows Server) On PM3.1 (CentOS) If I add more fields depending on this value the problem gets worse.
Could it be something with PHP or Apache, or maybe with the new PM version?
Thank you!
Alexis.
I installed a new server with 3.1 on CentOS Linux (Stack 205)
My previous version was 3.0 on Windows Server 2012.
I all work fine except when I use a combo which other fields depend on, I get a noticeable loss in performance comparing to previous server.
In this example I have 3 Fields and 1 Dropdown.
Code: Select all
The problem is that the browser will stay "blocked" 5 seconds while changing the dropdown value. If i do exacly same dynaform on the previous version, on windows, the change is almost instant. DROPDOWN (@@tipoPermiso): SELECT CADENA, DESCRIPCION FROM `PMT_WORKFLOWS` WHERE SECTOR = @@uSector
Field 1: SELECT CADENA FROM `PMT_WORKFLOWS` WHERE CADENA = @@tipoPermiso
Field 2 ( @@Cadena): SELECT APROBADORES FROM `PMT_WORKFLOWS` WHERE CADENA = @@tipoPermiso
Field 3:SELECT CONCAT (APROBADOR_1, ' ', APROBADOR_2, ' ', APROBADOR_3, ' ', APROBADOR_4, ' ', APROBADOR_5) from PMT_WORKFLOWS WHERE CADENA = @@Cadena
On PM3.0 (Windows Server) On PM3.1 (CentOS) If I add more fields depending on this value the problem gets worse.
Could it be something with PHP or Apache, or maybe with the new PM version?
Thank you!
Alexis.