Right now, filtering by visibilities requires scanning all rows. This slows down queries which should be faster, such as querying for counts. The solution might involve using file metadata to filter out entire files whose visibility values are higher that that of the user performing the query. Other solutions might also exist and should be explored for effectiveness.
Constraint: A solution should not require re-writing of existing data. Updating metadata, however, is okay.
Right now, filtering by visibilities requires scanning all rows. This slows down queries which should be faster, such as querying for counts. The solution might involve using file metadata to filter out entire files whose visibility values are higher that that of the user performing the query. Other solutions might also exist and should be explored for effectiveness.
Constraint: A solution should not require re-writing of existing data. Updating metadata, however, is okay.