Open jtojnar opened 1 year ago
It just runs SELECT count(*) AS amount FROM items WHERE thumbnail=:thumbnail for each thumbnail file, which takes about 650 ms on my server.
SELECT count(*) AS amount FROM items WHERE thumbnail=:thumbnail
Using SQLite.
It just runs
SELECT count(*) AS amount FROM items WHERE thumbnail=:thumbnailfor each thumbnail file, which takes about 650 ms on my server.Using SQLite.