@matigo In theory @randolph should like that too. Database optimisation FTW! :)
We have a basic CAD document management system here. I queried it earlier to find the number of files. Around 12 minutes after setting the query off and after complaints that the system had stopped I terminated it. Instant return to health.
What did I want? Simply list the files: if description is empty OR if description is not empty. :) Both searches if run independently take <15 seconds.
It's a metadata backed thing, each CAD file has associated folders and descriptive/history/revision/goat* files, and it's all stored on a general company server. 12600 CAD files require 141000 total files. I'm guessing the database is built every time the database program starts up it must build from all that metadata, and incrementally add…
Oops, lots of words. We're considering the upgrade to an SQL-backed thing from the same vendor. Should be interesting. :)
*No, not this.