Natalia
Aaron Fulkerson
11/18/2020, 10:03 PMAndreas Harmuth
11/19/2020, 7:50 AMtylim
11/19/2020, 3:37 PMtylim
11/19/2020, 3:38 PMtylim
11/19/2020, 3:38 PMtylim
11/19/2020, 3:38 PMtylim
11/19/2020, 6:45 PMJawad Sefiani
11/19/2020, 7:32 PMJohn Cantrell
11/19/2020, 8:13 PMJake
11/21/2020, 1:05 AMpzaenger
11/21/2020, 6:23 AMKJReactor
11/21/2020, 1:30 PMAhmet
11/21/2020, 8:33 PMtylim
11/22/2020, 3:43 PMtylim
11/22/2020, 3:44 PMtylim
11/22/2020, 3:45 PMtylim
11/22/2020, 3:45 PMOffset pagination does not scale at a database level. For example, if you skip 200,000 records and take the first 10, the database still has to traverse the first 200,000 records before returning the 10 that you asked for - this negatively affects performance.
tylim
11/22/2020, 3:46 PMconst results = await prisma.post.findMany({
where: {
email: {
endsWith: '<http://prisma.io|prisma.io>',
},
skip: 3,
take: 4,
})
so if i do something like thistylim
11/22/2020, 3:46 PMtylim
11/22/2020, 3:51 PMtylim
11/22/2020, 4:22 PMBohdan Kolosovsky
11/23/2020, 8:57 AMBohdan Kolosovsky
11/23/2020, 8:57 AMBohdan Kolosovsky
11/23/2020, 8:58 AMhuv1k
11/23/2020, 9:57 AMdefrex
11/23/2020, 9:49 PMupdate
by non-unique — or multiple-value — filters? eg.
prisma.post.update({
where: { id: { in: somePostIds } },
data: { status: Status.Published },
})
Armaan Dhanji
11/24/2020, 3:58 AMAaron Fulkerson
11/24/2020, 3:58 AMArmaan Dhanji
11/24/2020, 3:59 AM