tom-writes-code / rpgle-repl

A green-screen REPL style workspace to assist with RPGLE development
MIT License
26 stars 3 forks source link

Opening saved snippets is exceptionally slow #18

Open tom-writes-code opened 2 years ago

tom-writes-code commented 2 years ago

When taking the option to load snippets, REPLLOAD is very slow to open. It is also slow to change user, or toggle between saved/unsaved snippets.

The call stack shows that it is spending a long time sat here: image

The stated line is the "SELECT(...LISTAGG..." statement in fetchStoredSnippets()... which is almost certainly badly inefficient.