does filtering this way have any performance issues? is it a good practice?
yes i know they is or and where etc just asking 😀
12 Replies
it does
lol
unless there in no way
always filter on the database
more performance + less data in between = better experience
but it works ?
yes
usually you can search fine with it
full text search is a even better way
without full text search would look something like
Interesting this is how i have actually always done it
I still feel that the work to get full search working is kinda big
And i still haven't still understood the docs well
The fact that you have to specify the column you want to enable full search on etc
You can just do a includes search then
It works fine till i need to search for a number|big int data type then i will be forced to use equals instead of contain
The includes is just for strings
You can use another methods for numbers and such
gte: 10
eq: 8
And such
I thought gte ,lte where for Datetime
Prisma
Filtering and sorting (Concepts)
Use the Prisma Client API to filter records by any combination of fields or related record fields, and sort the results.
Didn't work
Didn't work