allow table wildcards for dbinfo type="columns"

Description

move the table exists checks to after the get columns, if the columns exists, then the table exists

https://github.com/lucee/Lucee/commit/16b8b84ad43e92c2eb9fd928ec9ea27af94cb27a

`dbinfo type="columns" table="%" datasource="mssql"`

https://docs.lucee.org/reference/tags/dbinfo.html#attribute-name

this change alone improves the reading the whole db schema process at startup of Preside by 25%, saving 500ms, without even using the wildcard option. simply by avoiding checkTable()

relates to

Activity

Show:

Zac Spitzer 19 March 2021 at 17:52
Edited

Fixed

Details

Assignee

Reporter

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Sprint

Fix versions

Priority

Created 18 March 2021 at 22:23
Updated 27 April 2022 at 17:06
Resolved 14 April 2021 at 18:13

Flag notifications