I went so far without coding, and built a big part of the Quality, Project and Office Management System for my company.
While there are still many functions I want to implement, learning better about APIs, the issue is the speed.
The overall experience is frustrating. I am using repeating groups almost everywhere. I tried to limit the use of extended vertical scrolling (that created infinite wait time in nested RG) and almost removed all the :filtered functions. But still the webapp is becoming slower and slower.
I am not even sure that if in case we are going to pay for a dedicated server we are going to to improve it.
Among the general slowness, one page is “ridiculously slow”, almost 10 minutes!
I explain now this specific page as critical example.
This is a report page that using 3 nested RG, searches among 2 or 3 different data types.
Here I completely removed all the :filtered, it’s on “search of”.
here the code of this page:
This is what I want to get. A table that shows for each month and for each employee, the following infpormation:
- how many hours are available (search of working hours per day of the employee * working days in the month - approved holidays)
- how many holiday booked (search of Approved holidays of the employee, in the related month)
- Hours booked in all the projects (these data is presented in many different way, but is based alsways on searches on the same type of data (“Labor Cost”) that includes field such as: employee, month, project, hours baseline, hours projected)
THIS PAGE TAKES almost 10 MINUTES TO LOAD!
one more thing: either with Opera, Firefox and Chrome, when the editor opens it start to use up to 2.5 GB! Is that normal?
Any help is appreciated.