Could xlr provide an API call that creates multiple variables in a single database insert operation? In cases where a large number of variables must be created dynamically by an executing release, the time to create one variable at a time can be costly, with one database io operation per variable (lock, write, unlock, etc.). A multi-variable create api might provide better efficiency if the dbms can support insertion of multiple rows in a single db query. It seems that most modern relational databases now support this.
by: Dave R. | 26 days ago | API & CLI tools
Comments
Thank you for suggesting a multi-variable create API. While we’re not planning to implement this soon, we recommend minimizing dynamically created variables during releases to improve performance. Consolidating data or using structured configurations may be more efficient.
We’ll monitor for more upvotes and customer use cases and are happy to discuss specific challenges or alternative solutions.