table color in sql edit.

when the SynEdit component is updated?

I already updated SynEdit in December, but there are already quite some new commits on its master branch.

I have read all the commits in December, but according to the annotations, the problem may be is still not solved.

Just filed a bug report: https://github.com/SynEdit/SynEdit/issues/28

Lajos-Juhasz commented 6 days ago I noticed this bug yesterday. My solution was to build the list in the temporary stringlist and assign the complete list to the highlighter. Most probably the reason for the slowdown is the TSynSQLSyn.TableNamesChanged.

Maybe we should add BeginTableNamesUpdate/EndTableNameUpdates.

I spent some time with debugging SynEdit. No luck. See my update in the ticket there. Hoping somebody can speed up the mentioned procedure.

The SynEdit ticket was solved some hours ago!

In my tests I simulated 50000 table names without a notifiable waiting time.

I merged the changes into HeidiSQL in r5111 so you can test yourself.

Thank you for your great work! I found a few bugs and remarks.

1. there is no hightlight color name database.
2. sometimes highlighted alias table.
3. if there is a sql query field and the table with the same name, the table highlights the color name.

3. if there is a sql query field and the table with the same name, the table highlights the color name.

Well, the highlighter is limited and not quite clever. It cannot detect whether you mean a column name or a table name. The highlighter is not comparable to the complexity of a query parser.

current highlighting (not valid): ... join rnas rn where rn.rnas = ''

valid highlighting: .. join rnas rn where rn.rnas = ''

Because in this example: rn - alias rnas, rn.rnas - field of table (alias) rnas (rn).

Yes, I already understood what you described. Only the highlighter is not capable to distinct between tables and columns. That's beyond what SynEdit does.