Redundant select queries (Pipeline list, Execution list) when fetching the list for the first time

[tomas-knap]

When getting list of pipelines for the first time, for each pipeline, the following select is executed 6x

16:56:03.200 [http-bio-8080-exec-8] DEBUG o.e.p.logging.sql - 2016-06-14 16:56:03.2--ServerSession(1609166314)--Connection(1158119237)--SELECT id, description, last_change, name, visibility, user_actor_id, user_id FROM ppl_model WHERE (id = ?)

bind => [4]

16:56:03.202 [http-bio-8080-exec-8] DEBUG o.e.p.logging.sql - 2016-06-14 16:56:03.202--ServerSession(1609166314)--Connection(1245490407)--SELECT id, description, last_change, name, visibility, user_actor_id, user_id FROM ppl_model WHERE (id = ?)

bind => [4]

16:56:03.204 [http-bio-8080-exec-8] DEBUG o.e.p.logging.sql - 2016-06-14 16:56:03.203--ServerSession(1609166314)--Connection(1544696816)--SELECT id, description, last_change, name, visibility, user_actor_id, user_id FROM ppl_model WHERE (id = ?)

bind => [4]

16:56:03.205 [http-bio-8080-exec-8] DEBUG o.e.p.logging.sql - 2016-06-14 16:56:03.205--ServerSession(1609166314)--Connection(1284352229)--SELECT id, description, last_change, name, visibility, user_actor_id, user_id FROM ppl_model WHERE (id = ?)

bind => [4]

16:56:03.207 [http-bio-8080-exec-8] DEBUG o.e.p.logging.sql - 2016-06-14 16:56:03.207--ServerSession(1609166314)--Connection(532056508)--SELECT id, description, last_change, name, visibility, user_actor_id, user_id FROM ppl_model WHERE (id = ?)

bind => [4]

16:56:03.208 [http-bio-8080-exec-8] DEBUG o.e.p.logging.sql - 2016-06-14 16:56:03.208--ServerSession(1609166314)--Connection(908474465)--SELECT id, description, last_change, name, visibility, user_actor_id, user_id FROM ppl_model WHERE (id = ?)

bind => [4]

Similarly, to get list of executions for the first time, the following select is executed 5x:

16:47:48.145 [http-bio-8080-exec-3] DEBUG o.e.p.logging.sql - 2016-06-14 16:47:48.145--ServerSession(1609166314)--Connection(1372246578)--SELECT id, backend_id, t_end, debug_mode, t_last_change, order_number, silent_mode, t_start, status, stop, user_actor_id, debugnode_id, owner_id, pipeline_id, schedule_id, context_id FROM exec_pipeline WHERE (id = ?)

bind => [8]

16:47:48.147 [http-bio-8080-exec-3] DEBUG o.e.p.logging.sql - 2016-06-14 16:47:48.147--ServerSession(1609166314)--Connection(1954199114)--SELECT id, backend_id, t_end, debug_mode, t_last_change, order_number, silent_mode, t_start, status, stop, user_actor_id, debugnode_id, owner_id, pipeline_id, schedule_id, context_id FROM exec_pipeline WHERE (id = ?)

bind => [8]

16:47:48.151 [http-bio-8080-exec-3] DEBUG o.e.p.logging.sql - 2016-06-14 16:47:48.151--ServerSession(1609166314)--Connection(1265126555)--SELECT id, backend_id, t_end, debug_mode, t_last_change, order_number, silent_mode, t_start, status, stop, user_actor_id, debugnode_id, owner_id, pipeline_id, schedule_id, context_id FROM exec_pipeline WHERE (id = ?)

bind => [8]

16:47:48.153 [http-bio-8080-exec-3] DEBUG o.e.p.logging.sql - 2016-06-14 16:47:48.153--ServerSession(1609166314)--Connection(1905903060)--SELECT id, backend_id, t_end, debug_mode, t_last_change, order_number, silent_mode, t_start, status, stop, user_actor_id, debugnode_id, owner_id, pipeline_id, schedule_id, context_id FROM exec_pipeline WHERE (id = ?)

bind => [8]

16:47:48.157 [http-bio-8080-exec-3] DEBUG o.e.p.logging.sql - 2016-06-14 16:47:48.156--ServerSession(1609166314)--Connection(1153656449)--SELECT id, backend_id, t_end, debug_mode, t_last_change, order_number, silent_mode, t_start, status, stop, user_actor_id, debugnode_id, owner_id, pipeline_id, schedule_id, context_id FROM exec_pipeline WHERE (id = ?)

bind => [8]

Solution: Get rid of redundant queries