09. Query Optimization/01. Foreign Keys (🏁 solution)

Foreign Keys

Loading "Optimizing Query Performance with Indexes in Prisma (🏁 solution)"

Optimizing Query Performance with Indexes in Prisma (🏁 solution)

👨‍💼 Adding indexes to foreign keys is a no-brainer 99% of the time. For very small tables it's probably not worth it, but even with small tables it's not going to hurt anyway.

But we're not done. We've got an actual major performance issue with our user search query we need to address.

← Previous Next →

Edit on GitHubEdit this page on GitHub

problem solution diff chat

💾data
How often do you need to run a migration?
Scott 🌌:
I just finished the Data Migrations workshop (I come from a No-SQL background). Let's say I add a n...
✅1
1 · 2 days ago
general
npm install everytime I setup a new playground
Duki 🌌:
Is it normal that I have to run `npm install` in my playground directory, everytime I setup the play...
✅1
2 · 13 days ago
general
Welcome to EpicWeb.dev! Say Hello 👋
Kent C. Dodds ◆ 🚀🏆🌌:
This is the first post of many hopefully!
18
80 · 6 days ago
💾data
Code snippets in workshop app
remich 🌌:
What is used to include the code snippets in the workshop app? I'd like to have syntax-highlighted P...
✅1
1 · a month ago
💾data
a very large insert
osmancakir 🚀 🌌:
hi all, I need to perform seeding to my deployment. I followed the steps in the database documentati...
✅1
2 · 6 months ago
💾data
📝forms
🔭foundations
Reviewing foundations, Mutations, Actions
silvanet 🚀 🌌:
Forgive me for this. I went over the file size limit. I don't want to sign up for being able to exce...
✅1
2 · 6 months ago
general
Migration to Vite: Server-only module referenced by client
Fabian 🌌:
Hi, I'm working on migrating to Vite following the remix docs (https://remix.run/docs/en/main/guides...
✅1
1 · 3 months ago
💾data
Undesired behaviors while running the data-modeling workshop
juliano.brasil 🌌:
After pulling the latest updates I started experiencing 2 undesired behaviors while running the wor...
✅1
2 · 5 months ago
💾data
📝forms
Getting a TS error that is not present in the course files
OtterlyPunk:
So I'm working in parallel and I'm feeling the problem is I'm using a new version of something in my...
✅2
12 · 8 months ago
general
Remix Vite Plugin
Binalfew 🚀 🌌:
<@105755735731781632> Now that remix officially supports vite (though not stable) what does it mean...
✅1
3 · a year ago
💾data
Prisma Typed SQL
Kent C. Dodds ◆ 🚀🏆🌌:
Hey <@&1123674184959148043> friends, check out the new Typed SQL feature in Prisma! I've added an ex...
2
2
0 · 3 months ago
general
🔭foundations
Solutions video on localhost:5639 ?
quang 🚀 🌌:
Hi, so I'm having a hard time navigating (hopefully will be better with time) The nav on epicweb.de...
✅1
9 · a year ago
💾data
Multi-Column Index - How does it eliminate the B-tree?
Darren 🚀 🌌:
So I just finished the Query Optimization - 02 Multi-Column Index lesson and was confused by the fol...
✅1
2 · 4 months ago
general
Epicshop is now social and mobile friendly!
Kent C. Dodds ◆ 🚀🏆🌌:
I'm excited to announce that now the Epic Web workshops are mobile friendly! https://foundations.ep...
🎉2
0 · 5 months ago
💾data
📝forms
🔭foundations
How can I do this?
silvanet 🚀 🌌:
Viewing the Intro (from the Workshop) for Mutations, the course has an embedded video where Kent exp...
✅1
3 · 6 months ago
💾data
Query optimization for queries generated by prisma
Allan 🌌:
Hi everyone! I finished the data modeling workshop this week and was inspired to do some query optim...
✅1
2 · 6 months ago
💾data
general
📝forms
🔭foundations
double underscore?
trendaaang 🌌:
What with the `__note-editor.tsx`? I don't see that in the Remix docs and I don't remember Kent talk...
✅1
2 · 6 months ago
🔐auth
💾data
08. ROLE-BASED ACCESS / 02. ROLES SEED - migration to local vs production
Fabian 🌌:
So I'm in a bit over my head with this one, in particular with how migration works in a local env vs...
✅1
1 · 6 months ago
💾data
data modeling 06/02 is missing part of the prompt
Allan 🌌:
In Data Modeling 06/02 the files include `server/index.ts` but there are no guiding emojis, no promp...
✅1
2 · 6 months ago
💾data
Why does TS not like Buffer being used when the return type of the blob appears to be Buffer?
OtterlyPunk:
I'm looking at the return types from Prisma and it appears that the `petImage.blob` is a `Buffer` ty...
✅2
5 · 7 months ago
💾data
🔐auth
Prisma batching in the Require Authorized (07/03/solution)
ajara 🌌 🚀:
When I did the `requireUser` function in `auth.server.ts` I thought about using `requireUserId` func...
✅1
4 · 7 months ago
💾data
🔭foundations
Handle Missing Data - Error when i'm using invariantResponse
Luan.ibarra 🌌:
Hello, I'm trying to use the invariantResponse utility from // "#app/utils/misc.ts" to do this in a...
✅2
2 · 7 months ago
💾data
Data Modeling: a real world scenario
trendaaang 🌌:
Kent, In the data modeling workshop, you mentioned that polymorphism is generally a bad idea in dat...
✅1
3 · 7 months ago
🔭foundations
💾data
general
📝forms
🔐auth
Native Logging
trendaaang 🌌:
I was thinking that it could be useful to log every CRUD operation to help track down errors. Is tha...
✅1
6 · 7 months ago
💾data
📝forms
Issues with child routes when loading a modal with actions (server/client)
OtterlyPunk:
I've set up a mini-project to go through the first set of videos and I'm having issues with the form...
✅1
7 · 8 months ago
general
The video play is pretty laggy currently
QzCurious 🌌:
I thought I should tag you for this <@105755735731781632>. Please take a look if something wrong.
✅2
9 · 8 months ago
general
New Workshop Scheduled
Kent C. Dodds ◆ 🚀🏆🌌:
Hey Epic Web devs! I wanted to let you know before everyone else on here: https://www.epicweb.dev/ev...
2
0 · 8 months ago

Create Post