Page 1 of 1
Difference between external sort and inline sort
Posted: Wed Jul 14, 2010 10:12 pm
by Manu1
Hi,
Could any one explain me the the difference between external sort and inline sort apart from external sort stage has more options?
I am trying to understand how they differ in terms of creation of OSH,usage of scratch disk and performance impact (If there are any more please mention them as well).
Posted: Wed Jul 14, 2010 11:15 pm
by ray.wurlod
Can you be more specific about what you mean by these terms? For example there's no such thing as an "external sort stage".
Posted: Thu Jul 15, 2010 12:01 am
by Manu1
ray.wurlod wrote:Can you be more specific about what you mean by these terms? For example there's no such thing as an "external sort stage". ...
external sort stage is the sort stage.
Re: Difference between external sort and inline sort
Posted: Thu Jul 15, 2010 12:34 am
by zulfi123786
In terms of orchestrate and scratch disk they are the same as they end up with the same tsort operator.
Posted: Thu Jul 15, 2010 1:43 am
by Sreenivasulu
I would also be curious to know the answer to this.
Regards
Sreeni
Posted: Thu Jul 15, 2010 2:00 am
by ArndW
The difference is that you have quite a few more options with the explicit sort stage as opposed to the implicit sort stage; they call up the same sort by default.
Posted: Thu Jul 15, 2010 2:22 am
by ray.wurlod
All three sorts (Sort stage, input link sort and inserted sort) cause a tsort operator to be included in the score. All three are governed by environment variables such as APT_TSORT_STRESS_BLOCKSIZE, obviously, because all three use the tsort operator.
Posted: Thu Jul 15, 2010 5:17 am
by chulett
They all use the same tsort operator, from what I understand.
<wink>