Latest post Fri, Sep 22 2017 8:32 AM by omsupport. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • Fri, Sep 22 2017 8:32 AM

    • omsupport
    • Not Ranked
    • Joined on Tue, Aug 20 2013
    • Posts 83
    • Points 900

    Efficiency of large searches

    Hi fellers,

    I'm investigating to find the quickest way to search the database for all assets with a particular attribute value.

    I'm restricting the search to start with a particular folder and to return the minimal set of attributes, but for a big database it can still take an hour or more to return the results.

    I'm considering these ways of speeding things up:

    1) Restrict each search to a particular type of asset. So for the complete set of results I'd need to search for clips, then sequences, then effects, etc...

    2) Restrict each search to a particular date range. So I'd then search for (say) everything checked in in the last day, then the week before that, then the month before that, then everything since the beginning of time...

    3) Do 1) or 2), but asynchronously so the searches all happen at the same time.

    Before I go into this in depth, does anyone know if any of these are likely to help, or will it just make things worse?


Page 1 of 1 (1 items)

© Copyright 2011 Avid Technology, Inc.  Terms of Use |  Privacy Policy |  Site Map |  Find a Reseller