Re: [Firebird-devel] Parallel execution

2017-04-20 Thread Vlad Khorsun
20.04.2017 17:50, Dimitry Sibiryakov wrote: > 20.04.2017 16:20, Vlad Khorsun wrote: >>> even in the simplest cases like "select f from t1 union select f from t2"? >> This case nor simplest nor better for parallel execution than "ordinary" >> "select * from t". > > Union used to produce

Re: [Firebird-devel] Parallel execution

2017-04-20 Thread Dimitry Sibiryakov
20.04.2017 16:20, Vlad Khorsun wrote: >> even in the simplest cases like "select f from t1 union select f from t2"? >This case nor simplest nor better for parallel execution than "ordinary" > "select * from t". Union used to produce plan SORT (T1 NATURAL), SORT(T2 NATURAL). Both record

Re: [Firebird-devel] Parallel execution

2017-04-20 Thread Dimitry Sibiryakov
20.04.2017 15:49, Leyne, Sean wrote: > "select f from t1 union select f from t2" is ONE statement with 2 parts! > > "Attachment" refers to the connection between a client and the server, it > does not imply anything about how the engine might decompose a statement or > how the parts could/would

Re: [Firebird-devel] Parallel execution

2017-04-20 Thread Vlad Khorsun
20.04.2017 13:04, Dimitry Sibiryakov wrote: > 19.04.2017 14:12, Vlad Khorsun wrote: >> Engine can't run more than one statement in attachment at same time. >> This will not be >> changed. > > Does it also mean that Firebird will never be able to execute parts of > single query in >