Autocomplete performance with with Better-Auth plummets with Zenstack adapter

[MatthewSH]

Description and expected behavior
This is a new one, when using specifically the Zenstack adapter for better auth the performance of autocomplete plummets. It's consistent across all editors too. Haven't dug into specifics past tracking down this specific cause

Videos
Too big for GitHub so I just uploaded them to Drive. Shows both VSCode and Zed.

https://drive.google.com/file/d/1yvYGSc-fvLS7OA86_qD1bEL6pdYdIEOz/view
https://drive.google.com/file/d/1o3FuLSazwKkR2SkK2BhGnW_mSU8FHPgd/view

Environment (please complete the following information):

• ZenStack version: 3.7.2
• Database type: Postgres
• Node.js/Bun version: 1.3.14
• Package manager: Bun

Additional context
Add any other context about the problem here.

[MatthewSH]

Exported-Composition-ECD9DE42-CDD3-4A99-8D36-A77DD98D9355.mp4

Dug a bit into it and it seems like it's directly tied to the typing with the database schema.

[ymc9]

Hi @MatthewSH , thanks for reporting this. I happen to be doing some tsc performance profiling/fixing. Could you upgrade zenstack packages to "@canary" tag (v3.8.0-beta.2) and see if it brings improvements?

[MatthewSH]

Hey @ymc9, thanks for the work! It is MUCH better. Still a bit slower than no database adapter, but I don't think that 100ms is a reasonable goal since it is accounting for a lot of extra types.

[ymc9]

Cool. It'll be part of the 3.8.0 release then.