Hello,
I see the "threads" branch of fossil has a lot of activity and seems close
to be finalized.
Will it be activated by default on the downloadable executable for windows ?
Will it apply to parallelisable CTE expression ?
Will it be possible from 1 sqlite.exe command line (or 1 python
sqlite.execute) to launch several SQL in parallel (and separated threads) ?
Typical workload case (that would be awesome if it could be 4 times
quicker) =
********************************************************************************************
- a long treatment reading a big table, which could be splitted into N
treatments reading 1/N th of the records of the big table.
- the N thread are adding the resulting records in 1 table.
This typical workload could also be defined as a big CTE :
with
resulset1 as (...),
resulset2 as (...),
resulset3 as (...),
resulset4 as (...)
select * from resultset1
union all
select * from resultset2
union all
select * from resultset3
union all
select * from resultset4
Regards,
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
