Query system fails for one million records in the database

[raghuvar-vijay]

If the number of records in the auditor database is 1 million, the query system fails to even retrieve one record.
This is due to the fact that the existing query string is not optimized and the database structure is not optimized to the use-case.

A query takes too long, approx 30-42 seconds to query a single record, such that the request is timed out.

The main problem is identified to be the scores which are stored as part of the component and the manner in which it is queried.

There is also another issue of uniformity - for meta the record id is stored in full where as for components it is referred to the id column of the accounting table.