So I am fairly new to sql and there is a particular query I make where the DB always timeout. I tried everything, including restarting the server.
There is this table where it listed all the events happening in an app, together with the person_role and the platform version it happened. So an example columnns and rows would be:
platform_id | aggregate_id | job_id | creator_id | event_type | timestamp | client | role | app_version|
so for example if I want to just check all the events associated with a particular job_id Ill just use a WHERE statement. Also take note that when I query other tables, there is no timeout, just this particular table.
I tried asking around and somebody recommended a stored procedure function to make the query faster. I tried it and actually it is just an empty table. Any other suggestions?
This is the simple query : SELECT * FROM db.events WHERE job_id = '1234566677'
To know all the events associated with that particular job_id.
