Laggy SQL Console.

[forbesmyester]

Description of the Issue

The SQL Console lags on keyboard input while it does IntelliSense guessing. If I type "abacus" it takes roughly 5 seconds for the text to appear on the screen whereas I can type it in less than one. During this time it's slowly adding letters, the pulldown menu is appearing and the cursor appears to show it's loading.

Steps to Reproduce the Issue

Type at a sensible speed in the field list area of an SQL statement that looks something like:

with j (req, calc_sheet_id, detail_sheet_id, location_id) as (
    values
        ('Client/Place',1406077,1159656,145726),('Client/Place',1607434,1599283,149018),('Client/Place',1607965,1607766,149330),('Client/Place',1611497,1595313,148588),('Client/Place',1612222,1611544,149334),('Client/Place',1610602,1609570,149032),('Client/Place',1633128,1591554,147940),('Client/Place',1591422,1591554,147934),
        ('Country/Place',1200708,1173687,146122),('Country/Place',1566181,1566140,147596),('Country/Place',1196628,1201329,145772),('Country/Place',1181210,1402791,147615),('Country/Place',1395290,1395539,146181),('Country/Place',1181434,1168903,146051),('Country/Place',1638604,1600134,149094),('Country/Place',1100250,1210432,146004),('Country/Place',1637369,1637345,150217)
),
file_details as (
    select
        j.*,
        calc_sheet.file_id as calc_file_id,
        (select original_filename from source_file where file_id = calc_sheet.file_id order by source_file_id desc limit 1) as calc_filename,
        calc_sheet.sheet as calc_sheet_name,
        detail_sheet.file_id as detail_file_id,
        (select original_filename from source_file where file_id = detail_sheet.file_id order by source_file_id desc limit 1) as detail_filename,
        detail_sheet.sheet as detail_sheet_name
    from j
    inner join sheets calc_sheet on calc_sheet.sheet_id = calc_sheet_id
    inner join sheets detail_sheet on detail_sheet.sheet_id = detail_sheet_id
    inner join calc_metadata on calc_metadata.file_id = calc_sheet.file_id
)
select * from file_details;

Expected Behavior

It should be easy to type

Actual Behavior

I have to stop for roughly 5 seconds after I input any field or table name for the SQL console to catch up.

Debug Information

Ubuntu 22.04, PostgreSQL database.

[forbesmyester]

I do want to add that I really like the tool otherwise. It does appear to probably be the best open source SQL client available in all other ways than the above.

[Wisser]

Hello,

Thank you very much for the report.
Here:
https://sourceforge.net/projects/jailer/files/12.7.1.2/
is a corrected version where hopefully the problem does not occur anymore. Please try it out.

[forbesmyester]

Wow, looks like you fixed it. Thanks.

Loving the project. I just spent a while looking for a "buy me a coffee" link so I could give something back, I'd use it if I found one.

Thanks again for the awesome tool!

[Wisser]

I reopen this to briefly share that this is now fixed in the new release 12.7.2.

Moreover, the autocompletion has been significantly improved. In particular, the column names of Common Table Expressions (and also those of inline views) are now recognized and suggested.

[forbesmyester]

Yes, it's way better and has been the thing that's transitioned me from a want-to-be-user to an actual-user. Thanks so much for your work on Jailer.