JIT code compilation during runtime based on runtime statistics
Systems, methods, and articles of manufacture, including computer program products, provide a system including at least one data processor and at least one memory storing instructions which, when executed by the at least one data processor, cause operations comprising: generating, by a database execution engine, a query plan including a plurality of operators; inserting, by the database execution engine, an enforce compilation operator into the query plan that includes the plurality of operators, the plurality of operators comprising a first operator, the enforce compilation operator, and a second operator; executing at least the first operator of the query plan; in response to executing the first operator, evaluating, by the database execution engine, an output of the first operator to determine whether a condition is satisfied; and in response to the condition being satisfied, triggering, by the database execution engine, a just-in-time compilation of the second operator.
1 . A system, comprising:
at least one data processor; and
at least one memory storing instructions which, when executed by the at least one data processor, cause operations comprising:
inserting, by a database execution engine, an enforce compilation operator into a query plan that includes a plurality of operators, the plurality of operators comprising a first operator, the enforce compilation operator, and a second operator;
executing at least the first operator of the query plan;
evaluating, by the database execution engine, an output of the first operator to determine whether a condition is satisfied; and
in response to the condition being satisfied, triggering, by the database execution engine, a just-in-time compilation of the second operator.
2 . The system of claim 1 , further comprising;
in response to the condition not being satisfied, inhibiting the triggering of the second operator, such that the second operator is not forced into the just-in-time compilation.
3 . The system of claim 1 , further comprising:
receiving, at the database execution engine, a query; and
generating, by the database execution engine, the query plan including a plurality of operators.
4 . The system of claim 1 , wherein the enforce compilation operator forces the just-in-time compilation of the second operator into at least machine code.
5 . The system of claim 1 , wherein the first operator comprises a first executable operator and the second operator comprises a second executable operator.
6 . The system of claim 1 , wherein the database execution engine inserts the enforce compilation operator into the query plan to optimize execution of the query plan.
7 . The system of claim 1 , wherein the condition is satisfied in response to a threshold value being exceeded.
8 . The system of claim 7 , wherein in response to the threshold value being exceeded, the database execution engine triggers the just-in-time compilation of the second operator.
9 . The system of claim 7 , wherein in response to the threshold value not being exceeded, the database execution engine inhibits the triggering of the second operator, such that the second operator is not forced into the just-in-time compilation but rather uses interpretive code for the second operator.
10 . The system of claim 1 , wherein the inserting the enforce compilation operator further comprises forking the output of the first operator to the enforce compilation operator and the second operator.
11 . A method comprising:
inserting, by a database execution engine, an enforce compilation operator into a query plan that includes a plurality of operators, the plurality of operators comprising a first operator, the enforce compilation operator, and a second operator;
executing at least the first operator of the query plan;
evaluating, by the database execution engine, an output of the first operator to determine whether a condition is satisfied; and
in response to the condition being satisfied, triggering, by the database execution engine, a just-in-time compilation of the second operator.
12 . The method of claim 11 , further comprising;
in response to the condition not being satisfied, inhibiting the triggering of the second operator, such that the second operator is not forced into the just-in-time compilation.
13 . The method of claim 11 , further comprising:
receiving, at the database execution engine, a query; and
generating, by the database execution engine, the query plan including a plurality of operators.
14 . The method of claim 11 , wherein the enforce compilation operator forces the just-in-time compilation of the second operator into at least machine code.
15 . The method of claim 11 , wherein the first operator comprises a first executable operator and the second operator comprises a second executable operator.
16 . The method of claim 11 , wherein the database execution engine inserts the enforce compilation operator into the query plan to optimize execution of the query plan.
17 . The method of claim 11 , wherein the condition is satisfied in response to a threshold value being exceeded.
18 . The method of claim 17 , wherein in response to the threshold value being exceeded, the database execution engine triggers the just-in-time compilation of the second operator.
19 . The method of claim 17 , wherein in response to the threshold value not being exceeded, the database execution engine inhibits the triggering of the second operator, such that the second operator is not forced into the just-in-time compilation but rather uses interpretive code for the second operator.
20 . A non-transitory computer-readable storage medium y storing instructions which, when executed by at least one data processor, cause operations comprising:
inserting, by a database execution engine, an enforce compilation operator into a query plan that includes a plurality of operators, the plurality of operators comprising a first operator, the enforce compilation operator, and a second operator;
executing at least the first operator of the query plan;
evaluating, by the database execution engine, an output of the first operator to determine whether a condition is satisfied; and
in response to the condition being satisfied, triggering, by the database execution engine, a just-in-time compilation of the second operator.