Fairly new to Shotgun, and I have a question about queries:
I am querying for element versions matching specific filters. That works fine, but when I hit a sequence with a lot of shots... things slow down (e.g. 45sec. wait period for result). I searched the forum for related information, but I could not get anything that would help me with my approach.
How should I go about improving response time? What do people do when they deal with a big query? What is the best way to cut it down to get a better and more interactive response?
Any pointer is welcome, as the dumb way works but does not seem too efficient. :)