K
Kysely•8mo ago
vicary

How to improve performance in large SELECT?

I have a large query with >100 selections, this makes VS Code hangs for type checking every 30s. I tried $assertType() with a hard-coded object type at the end of the select query, but it doesn't help much. Is there a recommended way for large inferred types?
1 Reply
Igal
Igal•8mo ago
Hey 👋🏻 can you provide a repository that reproduces this slowness?
Want results from more Discord servers?
Add your server
More Posts
Type inference of queries with expressions in WebstormWebstorm reports that the type of `const result = await selectable.select(({ eb }) => eb(eb.fn.counHow to compose functions?I have been unable to calculate `select count(id) > 0 from foo`. I tried this: `.select(({ eb }) =>How do I create a helper to be used on a select array of fields?I want to create a toBool helper to convert from tinyint, however I'm lost on the type I need to pasHow do I cast the type of a eb.fn('...') ?I tried with eb.fn<string>("CONCAT", [....]) but it didn't worked