Unusably slow with lots of resources

[cgutteridge]

One of our installs of librebooking has now got 110 resources and to generate some pages it's doing over 1000 SQL queries and taking over 100 seconds so I'm getting complaints.

Each query is only about 0.05 of a second so I don't think they can be optimised much more, but it's just the number that seems to be the problem.

[JohnVillalovos]

You could try in your config.php

$conf['settings']['schedule']['fast.reservation.load'] = 'true';  // Experimental: Use new algorithm to load reservations faster in the schedule. Currently does not support concurrent reservations. With larger number of resources this can be 10x or 100x faster. Only runs with the StandardSchedule otherwise will fall back to legacy mode.

Another option is to create multiple "Schedules" and split the resources among the schedules. See: Application Management -> Schedules.

That may help.

[cgutteridge]

Notable issues are:

/Web/schedule.php?dr=reservations
/Web/calendar.php?dr=events&sid=1&rid=&gid=&start=2025-04-28&end=2025-06-09&_=1746798421308

The calendar.php one takes over a minute to return. I'll try the suggestions now. Thanks.

[cgutteridge]

I've applied the fast reservation load setting and it seems that
/Web/schedule.php?dr=reservations went from about 90s to 30s -- a definite improvement but not going to make my users happy yet!

[JohnVillalovos]

Glad it helps. We have also split up resources into multiple schedules at my work. This has helped to make things faster.

Maybe somebody wants to do more work on improving the speed in the code. I did the work for fast.reservation.load but I'm sure things could be improved.

[cgutteridge]

ah, the user had set some scedules to show 14 or even 28 days. Cutting it down to 1 day has got it down to under 5 seconds load time. Not perfect but no longer unusable.

Btw, I am central IT for University of Southampton. I'm onboarding about 12 librebooking instances that were being run as grey IT and making it part of our main IT offering. A different install for each lab/department. The music department are using it for instruments and practice spaces so that was why this one has so many resources!

[JohnVillalovos]

@cgutteridge Glad you were able to get it to acceptable levels. Thanks for the update.