Hello,
After tyding up my SQL queries and checking with your tab on performances in your manual, my Performance sady still isn't as fast as i would like.
For Example a simple query like this:
SELECT `vendor`.`No_`, `vendor`.`Name`, `vendor`.`Name_2`, `vendor`.`Address`, `vendor`.`Address_2`, `vendor`.`Post_Code`, `vendor`.`City`, `vendor`.`Phone_No_`, `vendor`.`Fax_No_`, `vendor`.`E-Mail`, `vendor`.`Home_Page`, `vendor`.`ID` FROM `vendor` ORDER BY `vendor`.`Name` ASC, `vendor`.`ID`
..has 4778 results and is taking 6 seconds to load the page. It has no lookups and no formating functions etc.
The same Query takes 0,0016 Sec. in MariaDB to show results.
I have tried setting "$always_refresh_permissions" in config.php to 0 but it only improves the loading speed by max. 1 sec.
Do you have an Idea how to Fix this?
Thank you very much in advance.
Your current DaDaBIK version
You are using DaDaBIK version 10.1-Manarola enterprise, installed on 06-05-2020, the latest version of DaDaBIK is 10.1-Manarola released on 03-09-2020
You are runnning the last release of DaDaBIK
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enteprise to Platinum) please contact us.
System info
PHP Version: 7.3.18
mysql version: 5.5.5-10.4.12-MariaDB
Web server: Apache/2.4.43 (Win64) OpenSSL/1.1.1g PHP/7.3.18
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:77.0) Gecko/20100101 Firefox/77.0
URL installation: http://localhost/dadabik/
After tyding up my SQL queries and checking with your tab on performances in your manual, my Performance sady still isn't as fast as i would like.
For Example a simple query like this:
SELECT `vendor`.`No_`, `vendor`.`Name`, `vendor`.`Name_2`, `vendor`.`Address`, `vendor`.`Address_2`, `vendor`.`Post_Code`, `vendor`.`City`, `vendor`.`Phone_No_`, `vendor`.`Fax_No_`, `vendor`.`E-Mail`, `vendor`.`Home_Page`, `vendor`.`ID` FROM `vendor` ORDER BY `vendor`.`Name` ASC, `vendor`.`ID`
..has 4778 results and is taking 6 seconds to load the page. It has no lookups and no formating functions etc.
The same Query takes 0,0016 Sec. in MariaDB to show results.
I have tried setting "$always_refresh_permissions" in config.php to 0 but it only improves the loading speed by max. 1 sec.
Do you have an Idea how to Fix this?
Thank you very much in advance.
Your current DaDaBIK version
You are using DaDaBIK version 10.1-Manarola enterprise, installed on 06-05-2020, the latest version of DaDaBIK is 10.1-Manarola released on 03-09-2020
You are runnning the last release of DaDaBIK
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enteprise to Platinum) please contact us.
System info
PHP Version: 7.3.18
mysql version: 5.5.5-10.4.12-MariaDB
Web server: Apache/2.4.43 (Win64) OpenSSL/1.1.1g PHP/7.3.18
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:77.0) Gecko/20100101 Firefox/77.0
URL installation: http://localhost/dadabik/