K1|ller
K1|ller•7mo ago

Extremely slow queries

I'm having elapsed time of 2 to 5 seconds and I just switched from mongo to postgres. Is it the DB location? I'm hosting this app on render and using their postgres DB also takes really long. Supabase takes about the same time, any clue??
No description
3 Replies
K1|ller
K1|ller•7mo ago
hulp?
Nick
Nick•7mo ago
We can’t help you with this because it’s not a tRPC issue You may need to learn how to optimise your tables/queries which is a pretty big field that you can google about
K1|ller
K1|ller•7mo ago
it's querying 1 product lol
More Posts
TRPC works but getting unpredictable Typescript warnings for a barebones trpc monorepo projectHi, TRPC is working as expected but there are many warnings that feels very "off" for simple proceduKirimase's tRPC usage CRUD routeHey, using Nico's Kirimase tRPC package. I am trying to call the queries and mutations, in the db/scClient `tsc` checking server codeI have a trpc server and vite/react client set up in a pnpm monorepo. The VSCode type checking is beUnable to set up a client side subscription to a trpc route that supports websocketsI wrote the code on the client side here to query the subscription: https://github.com/sumanthneerumwhat's this union type doing(Zod)?I have 2 types of user, guest and registered(schemas). I have a union type with both and the guest dtrpc's useQuery with undefined input adds extra {"values":["undefined"]} to queryMy React app has several calls to query endpoints that have no input data but that do need useQuery Can you ensureData without the useUtils hook?The Tanstack Router docs recommend calling `ensureQueryData` in a route’s loader function if using THelp with queries vs mutationssuper basic question here from a newb to trpc...i see the calls are basically split into two type, qInterceptor in serverHow can I make an interceptor to get all the results before they are sent to the client, can I do thCan't do server side data fetching with RSC.Whenever I try to use a proxy client to fetch data in a React Server Component with Nextjs14, I get