which type of find would be faster?
I am scripting a find for records inside a database that has over 25million records. Each record represents the metadata from a camera rig recording at 24 frames per second.
I've currently got a mutlple find which says "look for images shot on THIS day and with THIS camera between the time stamps of This time and this time."
But given the volume of records, would it make more sense to do a successive series of contraints? "Find records from this date. Now find records from this camera. Now find the records between these two timestamps."
Any thoughts on which would be quicker, if either?
Thanks in advance.