95 lines
4.0 KiB
Plaintext
95 lines
4.0 KiB
Plaintext
|
# efficieny of mThreadedSpatialJoin
|
||
|
|
|
||
|
|
query setcore(6);
|
||
|
|
|
||
|
|
#2.4592sec / 5.37sec = 0.457951
|
||
|
|
#4.15114sec / 9.42sec = 0.440673
|
||
|
|
# 4.78051sec / 10.82sec = 0.441821
|
||
|
|
query roads feed head[1000] {o} roads feed {p} mThreadedSpatialJoin[Geometry_o, Geometry_p, 0.0] count;
|
||
|
|
#9.14762sec / 9.15sec = 0.99974
|
||
|
|
#6.46069sec / 6.46sec = 1.00011
|
||
|
|
#8.2505sec / 8.25sec = 1.00006
|
||
|
|
query roads feed head[1000] {o} roads feed {p} spatialjoin[Geometry_o, Geometry_p] count;
|
||
|
|
|
||
|
|
#11.8453sec / 16.07sec = 0.737107
|
||
|
|
#9.18222sec / 19.78sec = 0.464217
|
||
|
|
#9.07794sec / 19.63sec = 0.462452
|
||
|
|
query roads feed head[10000] {o} roads feed {p} mThreadedSpatialJoin[Geometry_o, Geometry_p, 0.0] count;
|
||
|
|
#10.7392sec / 10.73sec = 1.00085
|
||
|
|
#9.81972sec / 9.81sec = 1.00099
|
||
|
|
# 9.47158sec / 9.47sec = 1.00017
|
||
|
|
query roads feed head[10000] {o} roads feed {p} spatialjoin[Geometry_o, Geometry_p] count;
|
||
|
|
|
||
|
|
#31.5396sec / 38.67sec = 0.81561
|
||
|
|
#21.2174sec / 41.69sec = 0.508933
|
||
|
|
# 22.2303sec / 41.84sec = 0.531317
|
||
|
|
query roads feed head[25000] {o} roads feed {p} mThreadedSpatialJoin[Geometry_o, Geometry_p, 0.0] count;
|
||
|
|
#17.3387sec / 17.34sec = 0.999925
|
||
|
|
#11.6523sec / 11.65sec = 1.0002
|
||
|
|
#9.76949sec / 9.77sec = 0.999948
|
||
|
|
query roads feed head[25000] {o} roads feed {p} spatialjoin[Geometry_o, Geometry_p] count;
|
||
|
|
|
||
|
|
#(76.5789sec) /86.28sec = 0.887563
|
||
|
|
#40.1858sec / 78.98sec = 0.50881
|
||
|
|
#39.163sec / 73.14sec = 0.535452
|
||
|
|
query roads feed head[50000] {o} roads feed {p} mThreadedSpatialJoin[Geometry_o, Geometry_p, 0.0] count;
|
||
|
|
#16.457sec / 16.43sec = 1.00164
|
||
|
|
#15.1472sec / 15.14sec = 1.00048
|
||
|
|
#14.8478sec / 14.84sec = 1.00053
|
||
|
|
query roads feed head[50000] {o} roads feed {p} spatialjoin[Geometry_o, Geometry_p] count;
|
||
|
|
|
||
|
|
#(74.1421sec) /77.49sec = 0.956796
|
||
|
|
#92.3854sec) /167.42sec = 0.551818
|
||
|
|
#70.1011sec) /130.99sec = 0.535164
|
||
|
|
query roads feed head[100000] {o} roads feed {p} mThreadedSpatialJoin[Geometry_o, Geometry_p, 0.0] count;
|
||
|
|
#4.09094sec / 4.09sec = 1.00023
|
||
|
|
#20.4806sec / 20.47sec = 1.00052
|
||
|
|
#16.8385sec / 16.84sec = 0.999908
|
||
|
|
query roads feed head[100000] {o} roads feed {p} spatialjoin[Geometry_o, Geometry_p] count;
|
||
|
|
|
||
|
|
#(67.7913sec) /71.1sec = 0.953465
|
||
|
|
#5.47708sec / 26.46sec = 0.206995
|
||
|
|
#3.0912sec / 14.46sec = 0.213776
|
||
|
|
query roads feed head[100000] {o} roads feed head[1000] {p} mThreadedSpatialJoin[Geometry_o, Geometry_p, 0.0] count;
|
||
|
|
#6.08955sec / 6.09sec = 0.999927
|
||
|
|
#3.59915sec / 3.6sec = 0.999762
|
||
|
|
#3.42922sec / 3.43sec = 0.999773
|
||
|
|
query roads feed head[100000] {o} roads feed head[1000] {p} spatialjoin[Geometry_o, Geometry_p] count;
|
||
|
|
|
||
|
|
#(81.8595sec) /86.5sec = 0.946353
|
||
|
|
# 6.75954sec / 28.44sec = 0.237677
|
||
|
|
#7.28702sec / 21.45sec = 0.339721
|
||
|
|
query roads feed head[100000] {o} roads feed head[10000] {p} mThreadedSpatialJoin[Geometry_o, Geometry_p, 0.0] count;
|
||
|
|
#6.08955sec / 6.09sec = 0.999927
|
||
|
|
#5.0104sec / 5sec = 1.00208
|
||
|
|
#5.0492sec / 5.05sec = 0.999841
|
||
|
|
query roads feed head[100000] {o} roads feed head[10000] {p} spatialjoin[Geometry_o, Geometry_p] count;
|
||
|
|
|
||
|
|
#(81.8595sec) /86.5sec = 0.946353
|
||
|
|
#16.7908sec / 47.9sec = 0.350539
|
||
|
|
#16.4227sec / 36.57sec = 0.449077
|
||
|
|
query roads feed head[100000] {o} roads feed head[25000] {p} mThreadedSpatialJoin[Geometry_o, Geometry_p, 0.0] count;
|
||
|
|
#6.46825sec / 6.46sec = 1.00128
|
||
|
|
#7.37863sec / 7.38sec = 0.999815
|
||
|
|
#7.93002sec / 7.93sec = 1
|
||
|
|
query roads feed head[100000] {o} roads feed head[25000] {p} spatialjoin[Geometry_o, Geometry_p] count;
|
||
|
|
|
||
|
|
#(77.7879sec) /84.02sec = 0.925825
|
||
|
|
#30.7198sec / 73.55sec = 0.417672
|
||
|
|
# 29.7602sec / 59.27sec = 0.502113
|
||
|
|
query roads feed head[100000] {o} roads feed head[50000] {p} mThreadedSpatialJoin[Geometry_o, Geometry_p, 0.0] count;
|
||
|
|
#8.57639sec / 8.57sec = 1.00075
|
||
|
|
#7.12463sec / 7.12sec = 1.00065
|
||
|
|
# 8.35407sec / 8.35sec = 1.00049
|
||
|
|
query roads feed head[100000] {o} roads feed head[50000] {p} spatialjoin[Geometry_o, Geometry_p] count;
|
||
|
|
|
||
|
|
#80.2655sec) /88.62sec = 0.905727
|
||
|
|
#53.836sec / 115.25sec = 0.467124
|
||
|
|
#50.7021sec / 97.28sec = 0.521198
|
||
|
|
query roads feed head[100000] {o} roads feed head[100000] {p} mThreadedSpatialJoin[Geometry_o, Geometry_p, 0.0] count;
|
||
|
|
#10.8125sec / 10.81sec = 1.00023
|
||
|
|
# 11.0187sec / 11.01sec = 1.00079
|
||
|
|
#10.8919sec / 10.89sec = 1.00017
|
||
|
|
query roads feed head[100000] {o} roads feed head[100000] {p} spatialjoin[Geometry_o, Geometry_p] count;
|
||
|
|
|