GUI slow after the last update

[Burner1977]

Hello,

after the latest changes I have issues with a slow non responsive GUI. In my settings I have set to show 250 posts per page. When I scroll down and the GUI has to prepare the next 250 posts the GUI hangs. Results show after 30 seconds but before I can scroll again more then a minute is passed.
I have tested this in IE 11, Chrome and Firefox and they all react the same. Normally I never had any issues with this.
When I switch back to show 50 posts per page it is doable. Any thoughts what the issue can be?
Thanks in advance for the support.
Cheers
Burner1977

[int3nz0r]

I'm having similar issues like this.

[l-t-k]

same here

[Sweepr]

Running a query like OPTIMIZE TABLE commentsxover , spotstatelist , nntp , spots , spotsfull; also makes the database a bit faster.

[Sweepr]

https://github.com/Spotweb/Spotweb/wiki/Performance-tips

[dsadsdadsadsadsds]

Disable image preview on the spotlist as it apparently retrieves all images of all spots visible on the page. Especially if you do not have 'full' retrieval enabled, it will be severely slow.

[l-t-k]

Disabling the image preview did the trick!

[Burner1977]

Can you give me a hint where the option is. I can't seem to find it.

Thx

[Sweepr]

/templates/we1rdo/spots.inc.php

line 115:

[l-t-k]

Or:
Preferences / General Show subcats on mouseover in spots list

[l-t-k]

@Sweepr isn't it better to disable the image preview by default? I think many users are experiencing problems with it, because most of them will disable retrieve full spots.

[Sweepr]

@kooimens, effective, but no subcats ;-(

[l-t-k]

You're right. Would be useful to have the ability to set them both. One option to enable/disable subcat and one to enable/disable the image preview.

[Sweepr]

@kooimens, I'll create the feature request.

[Burner1977]

Jip found it. thanks for the tip.

Case closed