You are using DaDaBIK version 8.3-Lerici enterprise, installed on 05-15-2018 (installation code: 133425a7c786a0c929), the latest version of DaDaBIK is
Found
The document has moved here.
released on --
You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
PHP Version: 5.3.29
mysql version: 5.6.39-cll-lve
Web server: Apache
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36
--------
Hello,
I am having a latency issue with one section of my application. Here’s how the database is structured:
Table Appointments_and_Jobs contains appointment details and has a Customer field, which is a select single with Lookup table pointing to Customers and linked fields First_Name, Last_Name, and Telephone.
There are also tables Job_Details, Job_Visits, and Job_Documents. Each one has Job as a select single that points to Appointments_and_Jobs.
Currently there are about 25000 customers, but only 90 or so appointments so far. I can view the tables Customers, Job_Details, Job_Visits, and Job_Documents with no problem. However, when I go to Appointments_and_Jobs there is a huge latency issue. The application takes a very long time to display anything. As in 30 seconds or more each time. This happens when I just click on the link to the table in the menu, try to view a specific record, try to edit a record, or try to add a new item.
If I manually run queries on the MySQL database, the results are instant. I also optimized all the tables in the database, but this had no visible impact.
Please help.
Thanks,
Max
Found
The document has moved here.
released on --
You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
PHP Version: 5.3.29
mysql version: 5.6.39-cll-lve
Web server: Apache
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36
--------
Hello,
I am having a latency issue with one section of my application. Here’s how the database is structured:
Table Appointments_and_Jobs contains appointment details and has a Customer field, which is a select single with Lookup table pointing to Customers and linked fields First_Name, Last_Name, and Telephone.
There are also tables Job_Details, Job_Visits, and Job_Documents. Each one has Job as a select single that points to Appointments_and_Jobs.
Currently there are about 25000 customers, but only 90 or so appointments so far. I can view the tables Customers, Job_Details, Job_Visits, and Job_Documents with no problem. However, when I go to Appointments_and_Jobs there is a huge latency issue. The application takes a very long time to display anything. As in 30 seconds or more each time. This happens when I just click on the link to the table in the menu, try to view a specific record, try to edit a record, or try to add a new item.
If I manually run queries on the MySQL database, the results are instant. I also optimized all the tables in the database, but this had no visible impact.
Please help.
Thanks,
Max