thexerteproject / xerteonlinetoolkits

Xerte Online Toolkits
www.xerte.org.uk
Apache License 2.0
62 stars 61 forks source link

Performance issue on some systems with shared folders #1249

Closed torinfo closed 9 months ago

torinfo commented 9 months ago

I have had complaints from people about performance issues when loading the workspace. In some cases the workspace never loaded (timeout on the request). Sometimes it took some 30s to load the workspace.

It has to do with folder sharing, and specifically the queries to get the folders that you are not the creator of.

To fix the issue we need to add an extra index to the folderrights table and the templaterights table.

I will change basic.sql accordingly and also update upgrade.php.