Recently Added Slow Performance

[reidb...@gmail.com]

I have tracked down a weird performance regression and want to see if anyone else can confirm/noticed this. On a large installation running vanilla RS 9.5clicking on "Recently Added" takes about 5 seconds to load the results and then 4-5 seconds to click on an image and then arrow between them. Contrast this to running an arbitrary search (remember a large system), this takes 2-3 seconds and the arrowing between those resource results is virtually instant. Seemingly the return of simply the most recently upload 1000 images should be super fast, as should the paging between them...

There are two lines of code added in SVN revision 15004 that are the culprit. They seem to enable the functionality to sort by resource type in recent RS versions, but commenting them out restores the fast performance to Recently Added results. 

The lines are below, is anyone else seeing this/able to test the performance difference?

Thanks

// *******************************************************************************

// order by RESOURCE TYPE

// *******************************************************************************

$sql_join .= " JOIN resource_type AS rty ON r.resource_type = rty.ref ";

$select .= ", rty.order_by "; 

[Thomas Stefan]

I've had similar issues lately and I would be interested to test the code. In which file is the above located?

[reidb...@gmail.com]

That code is in include/search_do.php

Check to see if you just comment the lines out, if the recently added performance issue goes away!

[jum...@gmail.com]

Thanks! I tried that, but it does not seem to make much of a difference for the issue that I have experienced. 

What happens here is that whenever I try to load a search or a collection involving a lot of thumbnails, I am faced wih a spinning wheel animation and a waiting time of about half a minute. This seems to have started in a recent version. I added a CPU on my Google Cloud machine but it doesn't seem to help much.

There's another thread discussing recent performance issues:

https://groups.google.com/g/resourcespace/c/8pcfsDLEn_E/m/r84y07fvCwAJ

[jum...@gmail.com]

Update: I managed to fix the most pressing issue. I had created a non logged-in user and allowed them to search and access a custom search via a homepage tile.

These searches caused a long delay with a spinning wheel and seemingly impacted server load a lot.

In the RS user group permissions for this 'guest user' I tried disabling the bottom collection bar ('Lightbox'). 

This fixed the slow loading, now my site is very fast again.

[reidb...@gmail.com]

Interesting. That seems to point to some counting or querying all of the collections (to load into the collection selector in the col-bar) for a user when the page loads that is slow.