improve queryToStruct

Description

  • struct type should be ordered / linked ( i.e. matching query return type struct)

  • size the per row struct the to column count

  • only convert the column name to a key once

This will make it a little faster by sizing and only converting once., but then a little slower due to the ordered struct

overall slightly faster but more correct (struct being ordered)

relates to

Activity

Show:

Zac Spitzer 12 February 2025 at 22:24

before

[java] [script] Query.toStruct() member function 24 cols took 21,885ms [java] [script] Query returnType struct 24 cols took 38,965ms [java] [script] Query.toStruct() member function 5 cols took 7,083ms [java] [script] Query returnType struct 5 cols took 11,986ms

after

[java] [script] Query.toStruct() member function 24 cols took 17,881ms [java] [script] Query returnType struct 24 cols took 40,135ms [java] [script] Query.toStruct() member function 5 cols took 5,918ms [java] [script] Query returnType struct 5 cols took 12,011ms
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 12 February 2025 at 21:20
Updated 28 February 2025 at 08:52
Resolved 28 February 2025 at 08:52

Flag notifications