This was the solution I ended up going with
# orm-helps
Samuel Roth
01/29/2019, 6:48 PMThis was the solution I ended up going with
Samuel Roth
01/29/2019, 6:49 PMIf anyone has thoughts on the performance of this, let me know. It’s averaging around 30ms to complete right now in my test DB.
i
impowski
01/29/2019, 6:51 PMTry to create like 100000 emails and place all of them as friends, then run a query
đź‘Ť 1
impowski
01/29/2019, 6:51 PMI see nothing fishy right now, probably this will be like 500ms max
c
cb
01/29/2019, 7:20 PMYou could create an executeRaw(sql) test and compare the perf to an optimized query
s
Samuel Roth
01/29/2019, 10:33 PM@cb I was actually trying to do that but I couldn’t get it to work. I probably will figure it out down the line, but this works for now.