search

Assasans / found-footage

Content Warning mod that adds real lost footage from other players to your Old World.
MIT License
2 stars 0 forks source link

Database problems #26

Open Assasans opened 2 months ago

Assasans commented 2 months ago

There are now issues retrieving videos using the v3 API (v0.4.0+). Some queries do a tablescan, which generates a huge number of reads.

Assasans commented 2 months ago

Should be fixed, monitoring performance...

Assasans commented 2 months ago

The v3 API uses the same SQL query as /video/signed for now, as filtering with more parameters does not work efficiently in D1 (SQLite).