Hi naresh.chandra@copart.com, thanks for the bug report.
I couldn't reproduce the bug. Could you give us more details about it? e.g. steps to reproduce.
If it's possible, can you make the video record of the bug?

Oh, I think I can reproduce the bug by doing the following steps:

1. Send a query to a table with a lot of columns and rows. e.g . More than 50 columns, 10000 rows.
2. Start writing another query and there are slowness and lags.

This issue is related to https://jira.mariadb.org/browse/MXS-4728 which is optimized by automatically limiting the rendered columns to the maximum of 50 columns.

Did you have a query result with a lot of columns and rows when you faced this bug?

Duong,

1. Select schema(Use Schema)
2. Expand Tables(Load Tables)

Then try to write query from the first Tab, then first tab itself its very slow. I don't even run any other queries.

NOTE: I have only one active connection running at that time (One Query Editor with Only one Connection). and I have not run any queries but first query tab itself very very slow for typing the query.

naresh.chandra@copart.com Do you have a lot of schema nodes .i.e.
What is the result for this query:

SELECT

  COUNT(*)

FROM

  information_schema.SCHEMATA

Also, what is the total number of your tables:

SELECT COUNT(*) 

FROM information_schema.tables 

WHERE table_schema = 'your_database_name';

Have you tried to use the GUI in incognito tab where browser's extensions are disabled. The query editor uses web-workers to compute heavy tasks and some browser extensions could block the thread.

23.02.2 - It's been 6 months since we are using this version, its very fast and there was no lag in the query editor tab. Something has changed with 23.8 version I guess.

Hi naresh.chandra@copart.com thank you for the information. I'll try to reproduce the issue next sprint (week) and fix it asap. By the way, since you're here, do you mind clarifying the requirements for this feature https://jira.mariadb.org/browse/MXS-3851

Duong, Thanks for the update.

https://jira.mariadb.org/browse/MXS-3851 --> Posted my comments.

Hi naresh.chandra@copart.com, I suspect that this https://jira.mariadb.org/browse/MXS-4728 is one of the reasons that caused the issue, would you be able to install this version of the GUI to test it?
There is no need to reinstall maxscale, replace the `gui` dir in this path `maxscale/share/maxscale/gui` with the `gui` dir I attached and then restart maxscale. If that works, I'll backport the fix to 23.08 gui.zip

Hi Duong,

Sorry for the delay in responding. As you suggested I have replaced GUI directory then it's working fine, and I don't observe any slowness while typing a query. Could you please try to optimize or improve the GUI response if possible? Sometimes if we open multiple tabs running then GUI response is very slow.

Hi naresh.chandra@copart.com, so even with the version of the GUI I attached, there is still slowness with multiple tabs? Are all query tabs running queries?

No Duong, the slowness issue has been fixed with the attached GUI folder, but the slowness with multiple tabs I observed in both the 23.02 version and 23.08 version.

Ah okay, thank for the information. I'll try to backport the fix to 23.08 and maybe 23.02 if it's possible

Thanks Duong,

Hi naresh.chandra@copart.com,
We've addressed the typing slowness issue in the upcoming 23.08.04 release.

Regarding the slowness issue with changing the query tab, it requires a more intricate solution. The root cause comes from the large number of tables present (715 in your case - DOM pollution issue). In brief, we need to implement a virtualized tree for the schema explorer which requires changing the core component so we can't easily add it to the upcoming release. I added a separate ticket for that issue.
As a workaround, you could collapse the "Tables" node after expanding it to avoid this slowness while changing the query tab.

Hi Duong,

Thanks for the update. When will be the next version release date??

Hi naresh.chandra@copart.com, we released 23.08.03 about 3 weeks ago, so I don't think we're gonna release 23.08.04 any time soon. But you can expect it to be released before February 2024.

Hi Duong,

Thanks for the update.