Special handling of task sizes for interpreted code with high overhead

A system comprising:

• at least one processor;
• and
• at least one memory storing instructions that, when executed by the at least one processor, cause operations comprising:
• generating a query execution plan for a received query, wherein the query execution plan comprises one or more operators which will be interpreted by an interpreter when the query execution plan is executed;
• determining an overhead associated with preparation of the interpreter for executing the one or more operators of the query execution plan;
• determining a preferred task size based on removing the overhead associated with preparation of the interpreter;
• and
• during execution of the query execution plan, assigning tasks to one or more worker threads, wherein a task size of each assigned task is determined based on the preferred task size.

A non-transitory computer readable medium storing instructions, which when executed by at least one data processor, result in operations comprising:

• generating a query execution plan for a received query, wherein the query execution plan comprises one or more operators which will be interpreted by an interpreter when the query execution plan is executed;
• determining an overhead associated with preparation of the interpreter for executing the one or more operators of the query execution plan;
• determining a preferred task size based on removing the overhead associated with preparation of the interpreter;
• and
• during execution of the query execution plan, assigning tasks to one or more worker threads, wherein a task size of each assigned task is determined based on the preferred task size.