Re: Multiple sqlworkers

[Ole Tange]

On Sun, Jun 7, 2020 at 8:01 PM Thomas Bereknyei <tomberek@gmail.com> wrote:
>
> Running your example with sqlite gives me the same result. I suspect
> sqlite enforces a bit more serialization when it comes to the results,
> while something like postgres allows multiple queries in flight. This
> example gives me numbers like 187, 201, 193, 190....
>
> seq 100 | parallel --sqlmaster postgresql:///tom/tabl 'sleep 1; echo {}'
> (
> parallel -uj30 --sqlworker postgresql:///tom/tabl &
> parallel -uj30 --sqlworker postgresql:///tom/tabl &
> parallel -uj30 --sqlworker postgresql:///tom/tabl &
> parallel -uj30 --sqlworker postgresql:///tom/tabl & wait ) | wc -l

Try git version.

/Ole