- Mon Oct 17, 2016 8:26 am
#787005
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.
Last edited by alexisjavier on Mon Oct 24, 2016 8:11 am, edited 1 time in total.