ILP block (add-on)

 
 
Wiltshire College
ILP - Slow Page Load
 

Hi,

This is a recent development but when staff/students try to access the ILPs via a link in a course, the dashboard is taking an age to load.

The slowdown occurs at the same time each week - Wednesday lunchtime - and then tends to resolve itself by later on the Wednesday afternoon.

I've been puging all caches and running the cron in a hope that this might do something but to no avail.

Anybody else getting this?

 

 
Average of ratings: -
Picture of Richard Havinga
Re: ILP - Slow Page Load
 
HI Matt,

Just a thought. Do you have any MIS integrations setup? Is there any inserts or updates happening at that particular time?

Richard
 
Average of ratings: -
Picture of North West Kent College
Re: ILP - Slow Page Load
 

Hi,

We are having the same issue with the PLP/ILP dashboard and subsequent page being slow to load - this is all the time.

We have tried to set the query_cache variable to 64MB but this doesn't have any effect.

Can anybody offer any advice on what to look for to try and resolve this?  The rest of our Moodle implementation does not have any issues with speed!

Would it be something we need to do with the ILP tables in the database e.g. somehow optimise them?

Any advice or tips would be greatly appreciated.

Thanks in advance.

 
Average of ratings: -
The fox I once modeled, vertex by vertex, so to me it is no ordinary fox
Re: ILP - Slow Page Load
 

I think this is related to the query calculating the number of 'Overdue' reports. e.g.

1/3 Achieved
2 Reports overdue

After about 10,000 reports in total, our staff overview slowed up, particularly in a course with 2k+ student enrolments ...

My current work around is to display the 'date' of the last updated report instead sad

Hope this helps

Jago Brown


 
Average of ratings: -
Picture of Richard Havinga
Re: ILP - Slow Page Load
 
Hi Jago,

This is a known issue and is fixed in our customer release but unfortunately has yet to make it to the community release. It was resolved by applying indexing.

Thanks

Richard
 
Average of ratings: -
The fox I once modeled, vertex by vertex, so to me it is no ordinary fox
Re: ILP - Slow Page Load
 

Hi Richard,

These were/are the indexes we have applied. Could you let us know how these differ from your customer release? :

mdl_block_ilp_entry:

Keyname                                   Type Unique Column
PRIMARY                                   BTREE Yes     id
mdl_blocilpentr_rep_ix             BTREE No     report_id
mdl_blocilpentr_cre_ix             BTREE No     creator_id
mdl_blocilpentr_use_ix            BTREE No      user_id


mdl_block_ilp_plu_dd_ent:

Keyname                                   Type Unique Column
PRIMARY                                    BTREE Yes    id
mdl_blocilppluddent_par_ix      BTREE No     parent_id

 

mdl_block_ilp_plu_ste_ent:

Keyname                                    Type Unique  Column
PRIMARY                                    BTREE Yes      id
mdl_blocilpplusteent_par_ix     BTREE No       parent_id

...


Kind regards

Jago

 
Average of ratings: -
Picture of Nathan Friend
Re: ILP - Slow Page Load
 

Hi, 

I would also be intrested to know of any indexes added to improve the performace.

Can you post the exact ALTER comands you used?

Cheers,

 

Nahtan.

 
Average of ratings: -
Picture of Nathan Friend
Re: ILP - Slow Page Load
 

Hi Richard,

Any chance you could share how the indexing was added.

Cheers,

Nathan.

 
Average of ratings: -
Wiltshire College
Re: ILP - Slow Page Load
 

We did this using Moodle Adminer... it was just a question of selecting the appropriate tables and using the Alter Indexes link - no SQL required.

 
Average of ratings: -
Picture of Nathan Friend
Re: ILP - Slow Page Load
 

Hello Matt,

Thanks for the reply, I've installed Adminer now.  Can you tell me which tables and index settings I need to enter?

 

Cheers,

 

Nathan.

 
Average of ratings: -
Picture of Nathan Friend
Re: ILP - Slow Page Load
 

Hi All,

I've enabled slow query log in mysql.  When I go to the view_studentlist I'm getting.

# Time: 130503 8:34:09
# Query_time: 35.317521 Lock_time: 0.000073 Rows_sent: 0 Rows_examined: 21649
SET timestamp=1367566449;

SELECT e.id
FROM mdl_block_ilp_entry as e,
mdl_block_ilp_plu_ddl_ent as ddlent,
mdl_block_ilp_plu_ste_ent as pe,
mdl_block_ilp_plu_ste_items as pi
WHERE e.id = ddlent.entry_id
AND e.report_id = 1
AND e.user_id = 8169
AND ddlent.value < 1367566325
AND e.id = pe.entry_id
AND pe.parent_id = pi.id
AND pi.passfail = 0;

So it looks like this is where I need to apply indexes, can anyone advise?

 

 
Average of ratings: -
Picture of Nathan Friend
Re: ILP - Slow Page Load
 

Sorry about the flood, used the back button.

We've added:

ALTER TABLE mdl_block_ilp_plu_ddl_ent ADD KEY `mdl_block_ilp_plu_ddl_ent_entry_id_idx` (`entry_id`);

So far there appears to be a vast improvement.

 
Average of ratings: -
Wiltshire College
Re: ILP - Slow Page Load
 

Hi,

We indexed:

  • mdl_block_ilp_plu_ddl_ent entry_id
  • mdl_block_ilp_plu_ddl_ent entry_value
  • mdl_block_ilp_plu_ste_ent.parent_id

 

 
Average of ratings: -
Picture of Nathan Friend
Re: ILP - Slow Page Load
 

Thanks, sure has made a improved the access speed.

 
Average of ratings: -
Picture of Nathan Friend
Re: ILP - Slow Page Load
 

Thanks, sure has made a improved the access speed.

 
Average of ratings: -
Picture of Richard Havinga
Re: ILP - Slow Page Load
 
Thanks Matt for providing this to Nathan. This indeed is what we applied.

Richard
 
Average of ratings: -