09. Query Optimization/02. Multi-Column Index (🏁 solution)

Multi-Column Index

Loading "Optimizing User Search Query Performance with Indexing (🏁 solution)"

Optimizing User Search Query Performance with Indexing (🏁 solution)

👨‍💼 I know that was a lot of work for a single line code change, but honestly a lot of the time, performance work is like that.

And this made a huge impact. We were thinking about adding a couple Redis clusters and pumping up the specs of our server to deal with this slow query and now we don't have to bother because we have a good index. You've just saved us many many dollars. Here, have a raise. 🤑

Great work!

← 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 · 3 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 · 14 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