© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•3y ago•
3 replies
karma

magical operator sql`` is faster than query/select?

im not sure, that i did it correct, but i deice to fetch with different ways specific talbes, and make kinda banchmarks with console.time/timeEnd and saw a lot of different in this
sql``:0.361ms average
query: 1.532ms average
select:0.981ms average

did i do something worng or this is true, if so, what is the reason to use query and select?
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Magic sql'' operator concat
Drizzle TeamDTDrizzle Team / help
11mo ago
Magic sql`` operator array
Drizzle TeamDTDrizzle Team / help
3y ago
Raw SQL much faster (200x) than Drizzle for some queries
Drizzle TeamDTDrizzle Team / help
2y ago
Drizzle Query Returns Different Result Than Select
Drizzle TeamDTDrizzle Team / help
2y ago