Skip to content
This repository has been archived by the owner on Jan 18, 2023. It is now read-only.

Cache query plans #27

Open
mwest1066 opened this issue Jul 17, 2019 · 0 comments
Open

Cache query plans #27

mwest1066 opened this issue Jul 17, 2019 · 0 comments
Labels
enhancement New feature or request

Comments

@mwest1066
Copy link
Member

Change sql-loader.load() to return an object rather than a string, including a unique name:

{
    name: filename + ‘-‘ + block_name,
    text: sql_string
}

See https://node-postgres.com/api/client#-code-client-query-config-queryconfig-gt-promise-lt-result-gt-code-

This triggers execution plan caching in the DB: https://node-postgres.com/features/queries#parameterized-query

@mwest1066 mwest1066 added the enhancement New feature or request label Jul 17, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant