Thank you for your reply. My comment was not related to the absolute best performance, but a more performant way to fetch data than going through VBS for every request. I think wiring up all the queries and joins manually for a complex system as VB will take so much time that the API is obsolete before it's done, and with the performance in existing ORMs I see no reason to invent the wheel again. I'm mentioning specifically EF Core because that's what I have experience with and have been tinkering with using the Business data model, scaffolding and GraphQL. Dapper or other ORMs might have scaffolding solutions, but I know nothing about that. I think the API would benefit tremendously by skipping the VBS for queries that don't access calculated fields. This would probably also lower the compute power required to run the API-solution, as much of the query can be off-loaded to the SQL-server(s). Computed fields can be fetched using a data loader using primary keys. I'm seeing a 10x improvement in query times using the SQL+dataloader approach over the implementation in nxt, using approximately the same dataset. I'm happy to demonstrate this over teams.
... View more