Toot

Written by Jenniferplusplus on 2025-01-21 at 23:16

@puppygirlhornypost2 No, at this point it doesn't actually matter if we already know this actor exists or not.

Basically, there's a lot of SELECT x FROM profiles WHERE profiles.id in (a, b, ..., n). Which is great if n is a tiny fraction of the size of the profiles table. But it can get pushed into not-fine if n is large. So my concern isn't that I might have to do 10,000 AP fetches. That would be annoying, but I don't expect it would affect stability*. It's that I might have to do a half dozen WHERE IN queries where the IN collection is 10,000 url strings

edit:

• I don't expect it would affect Letterbook's stability. Can't speak to our neighbors. I'll need to figure out how to be a good neighbor about that, too. But one thing at a time.

=> More informations about this toot | View the thread | More toots from jenniferplusplus@hachyderm.io

Mentions

=> View puppygirlhornypost2@transfem.social profile

Tags