April 2nd, 2002

(no subject)

There are 755 gallery images in the Juliecam gallery. So counting thumbnails, there are 1,550 active gallery files. But on the server there are 3.278 files in the gallery folder.

I'm going to write a script to delete the unused files. It will have to perform 3,278 SQL queries to determine if each file is used or not (because I'm an untalented hack when it comes to SQL programming).

SQL server, prepare for a beating.