TOPIC:

We (chrome inspector and I) experience that, since version 3.0, xerte's performance has become worse. And while I update every time (timely), i thought i'd start a topic about it.

Total load time is around 16-18 seconds.
In the larger perspective (looking at moodle and building courses in xerte) the browsing speed is relatively okey.... exept for xerte's main screen.
The main screen, starts off okey, then loads get_templates_sorted.php (it spends a majority (~12s.) of the time doing something), then it presents the jstree and finishes loading.

Am I the only one experiencing these problems and how did I mess up? (added chrome inspector trace)

My personal experience is different. It loads in about 700ms in total, spending 116ms in get_templates_sorted.

However, I have only about 30 LO's in my workspace and I am working with a LAN connection.

So, in order to know whether there is really an issue, can you give us some more information:

OS of client
OS of server
Number of LO's in the installation
Number of LO's in your workspace

Is the server hosted by your institution, or is it hosted by a 3rd party?

We take these kinds of performance issues very seriously, and we have installation with up to 25000 LO's without issues, so we need more information to be able to comment on your specific situation.

I just tested one of my installations too and total load time about 950ms and get_templates_sorted 101 ms.

I look after lots of different installations with a wide variety of configurations and have never noticed loading time to be an issue. I wonder if this could be an authentication issue e.g. are you using LDAP and a large number of users? Or perhaps there are some customisations or firewall settings causing this?

HTH
Ron

Briljant Guys,

181 LO's in my window, seperated over 10 folders.
In total ~250 in the database..
Connected on LAN, server hosted ourselves, VM.
Ubuntu 14.04.5 LTS
The server is shared with moodle and has caching enabled.
This happens on Windows 7/8/10 clients and Ubuntu 14.04/16 Clients (usergroup~ 100 man).
Experience is roughly the same for chrome,edge,iexplorer and firefox (with firefox on ubuntu being the fastest).

We use LDAP with moodle and authentication using moodle


25000 sounds like a lot:P


@RON,

Only customization is
export.php,
template_status.php
export_template.php
Where I enabled the export for editors by (in each of the php files) adding
"is_user_an_editor($_POST...$session logonid) ||

such that editors can export the scorm package

The only time we've experienced these kinds of perfomances was when we allowed 'localhost' as a database host on Windows machines. Is your VM running on a Windows host?

In database.php, is the database server localhost? If so, try replacing it with 127.0.0.1 (done by more recent installers automatically)

Does this help?

If not, we need to go through the functionality of get_tempates_sorted, which is primarilly MySQL queries....

Nice thinking!

I did the checks:
database.php ->127.0.0.1
The VM is a regular Ubuntu 14.04 Lamp stack

When the system only returns 2 courses, template.php takes only 268 ms (milisecond)
Which means that it is the shear number of results, 181 LO's
Is it possible to run into some query time limit?


Edit [12-10-2016 15:55]
I turned on the logging feature in xerte and this is what it does (I firewalled off other users, Im the only one):


2016-10-12 15:48:30 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:30 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:30 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:30 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:30 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:30 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:30 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:30 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:30 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:30 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:30 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:31 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:31 /var/www/html/moodle/xerte/website_code/php/display_library.php461Running : select td.template_name as project_name, otd.template_name, otd.template_framework, td.template_id, tr.role from xer_templatedetails td, xer_templaterights tr, xer_originaltemplatesdetails otd where td.template_id = tr.template_id and tr.user_id = ? and tr.folder= ? and otd.template_type_id = td.template_type_id order by td.date_created DESC
2016-10-12 15:48:31 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:31 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:31 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:32 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:33 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:34 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?
2016-10-12 15:48:34 /var/www/html/moodle/xerte/website_code/php/database_library.php175Running : select * from xer_templaterights tr, xer_folderdetails fd where tr.role='creator' and tr.folder=fd.folder_id and tr.template_id=?