Are the dqsegdb database tables actually indexed?
@robert.bruntz @ryan.fisher @stuart.anderson @philippe.grassia
I've been watching at the dqsegdb server upgrade from a 30,000ft perspective. Unless I'm looking in the wrong place, is this the right folder that contains the database schemas that are used for the production database?
If so, and unless I'm not seeing it, or unless it's been implemented and not in version control, it looks like none of the tables are indexed. Is that the case?
If so, then having an unindexed table with multiple users making queries is 100% the cause of seeing increased and unsustainable load on your database. Early on in O3 and before O4a, there were a few corner cases where users would hit GraceDB with unindexed queries which would bring the service to crawl. But a few lines of SQL fixed the problem.
Everyone's busy, but I can spare some cycles to help out if need be; just let me know.