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?

Geoff.