Web UI lags

[koftnt]

HI all,
I encountered unbearable UI stutters.
There are over 100 times runs and tens of thousands of isuues in my DB. Sapp UI lags because of query DB

More accurate ，following code takes a long time:

Ask for help
Please tell me how to improve and reduce time costs

[arthaud]

Hi @koftnt,

Could you point us to actual code, with path and line numbers?
Querying all issues is a bad idea for big codebases. We should always add limits to our queries and only provide the first X issues.

Note that this UI is barely maintained because we unfortunately use a different UI internally.

[koftnt]

hi @arthaud
It is https://github.com/facebook/sapp/blob/main/sapp/ui/issues.py#L448

[arthaud]

I'm not sure what's the problem. It seems like this should be pretty fast since this only query issues with a specific id. With the right index in the database, this should be quite fast.

Maybe we could try printing out that query (LOG.info(str(query))) and try executing it manually, see what's slow?