Mediaflux: Performance tuning

[Jason Lohrey]

Hi Sean,

I note a few performance tuning things you need to do.

By default, Mediaflux is a database used by a number of OEMs and use-cases. It does not have all of the indexes enabled.

If you run queries of the form:

asset.query :where namespace>=‘xx’ 

Any time you have a view that maps to a namespace, you are doing just that.

Then you will benefit from indexes on each of the namespaces in the true. The best index you can add is:

asset.namespace.contained.asset.index.create :cascade true :namespace /

It makes quite a difference to those namespace queries as above.

Jason

JASON LOHREY

Chief Technical Officer