-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathlog_testsqlite_1.txt
72 lines (44 loc) · 6.65 KB
/
log_testsqlite_1.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
SSSSSSSSSSSSSSSS----TestRun(insert(10000))----SSSSSSSSSSSSSSSS
插入 10000 总耗时:56.112000 毫秒
-----TestRun(insert(10000)) 耗时67.706000-----
------------TestRun(query(10000))-----------
查询条件:box[(-135.672027,86.248054)-(-134.686173,87.233909)],744824284<=dtime<=140599694408585,sat=4
查询结果(仅输出ID)：272,1635,1797,2561,3298,3414,3534,6101,6561,7423,9364,9694,9719,9805,
查询(仅范围) 20000 总耗时:14562.898000 毫秒
查询条件:box[(-135.672027,86.248054)-(-134.686173,87.233909)],744824284<=dtime<=1995918677546930,sat=4
查询结果(仅输出ID)：3298,9719,9805,
查询(全条件) 20000 总耗时:14537.119000 毫秒
EEEEEEEEEEEEEEEE----TestRun(query(10000)) 耗时29143.844000----EEEEEEEE
SSSSSSSSSSSSSSSS----TestRun(insert(50000))----SSSSSSSSSSSSSSSS
插入 50000 总耗时:327.304000 毫秒
-----TestRun(insert(50000)) 耗时383.404000-----
------------TestRun(query(50000))-----------
查询条件:box[(-135.672027,86.248054)-(-134.686173,87.233909)],744824284<=dtime<=140599694408585,sat=4
查询结果(仅输出ID)：272,1635,1797,2561,3298,3414,3534,6101,6561,7423,9364,9694,9719,9805,10103,10423,10564,10652,10845,11062,12660,12883,12979,13250,13770,14118,14597,15729,15917,16177,17045,17244,17579,17892,18427,19684,20779,21562,22218,22458,23266,23541,23575,23803,24256,25282,25621,26854,26908,27670,28083,28751,28788,30489,31784,32553,34137,34154,34587,36619,37302,37904,38141,38508,38670,38724,38814,39901,40554,40694,41071,41490,41642,42484,43174,43716,44448,46232,47757,48839,49424,49951,49993,
查询(仅范围) 20000 总耗时:73254.109000 毫秒
查询条件:box[(-135.672027,86.248054)-(-134.686173,87.233909)],744824284<=dtime<=1995948205036313,sat=4
查询结果(仅输出ID)：3298,9719,9805,10564,11062,12883,17244,28751,31784,37302,40694,41490,41642,
查询(全条件) 20000 总耗时:73135.015000 毫秒
EEEEEEEEEEEEEEEE----TestRun(query(50000)) 耗时146434.107000----EEEEEEEE
SSSSSSSSSSSSSSSS----TestRun(insert(100000))----SSSSSSSSSSSSSSSS
插入 100000 总耗时:703.962000 毫秒
-----TestRun(insert(100000)) 耗时814.515000-----
------------TestRun(query(100000))-----------
查询条件:box[(-135.672027,86.248054)-(-134.686173,87.233909)],744824284<=dtime<=140599694408585,sat=4
查询结果(仅输出ID)：272,1635,1797,2561,3298,3414,3534,6101,6561,7423,9364,9694,9719,9805,10103,10423,10564,10652,10845,11062,12660,12883,12979,13250,13770,14118,14597,15729,15917,16177,17045,17244,17579,17892,18427,19684,20779,21562,22218,22458,23266,23541,23575,23803,24256,25282,25621,26854,26908,27670,28083,28751,28788,30489,31784,32553,34137,34154,34587,36619,37302,37904,38141,38508,38670,38724,38814,39901,40554,40694,41071,41490,41642,42484,43174,43716,44448,46232,47757,48839,49424,49951,49993,50891,52434,52632,52905,53123,53458,54335,54887,54928,55079,56492,57102,57234,58188,59665,60444,60478,60544,60936,61331,63345,63812,64857,65266,65875,65940,66017,66675,67740,68429,68603,68743,68803,69432,70206,70313,70504,71617,72763,73262,76063,77210,77896,78940,79172,80420,80452,80674,80702,81925,82177,82613,83962,84311,84625,85567,85853,87643,87835,90151,90550,90936,92369,92611,92872,93451,94136,94852,95764,96095,96780,96955,98540,98689,
查询(仅范围) 20000 总耗时:150815.396000 毫秒
查询条件:box[(-135.672027,86.248054)-(-134.686173,87.233909)],744824284<=dtime<=1996095453907474,sat=4
查询结果(仅输出ID)：3298,9719,9805,10564,11062,12883,17244,28751,31784,37302,40694,41490,41642,52434,54887,54928,59665,60444,60936,67740,68429,68803,69432,70313,72763,73262,81925,82177,90550,90936,92872,
查询(全条件) 20000 总耗时:149699.382000 毫秒
EEEEEEEEEEEEEEEE----TestRun(query(100000)) 耗时300564.223000----EEEEEEEE
SSSSSSSSSSSSSSSS----TestRun(insert(200000))----SSSSSSSSSSSSSSSS
插入 200000 总耗时:1533.875000 毫秒
-----TestRun(insert(200000)) 耗时1758.189000-----
------------TestRun(query(200000))-----------
查询条件:box[(-135.672027,86.248054)-(-134.686173,87.233909)],744824284<=dtime<=140599694408585,sat=4
查询结果(仅输出ID)：272,1635,1797,2561,3298,3414,3534,6101,6561,7423,9364,9694,9719,9805,10103,10423,10564,10652,10845,11062,12660,12883,12979,13250,13770,14118,14597,15729,15917,16177,17045,17244,17579,17892,18427,19684,20779,21562,22218,22458,23266,23541,23575,23803,24256,25282,25621,26854,26908,27670,28083,28751,28788,30489,31784,32553,34137,34154,34587,36619,37302,37904,38141,38508,38670,38724,38814,39901,40554,40694,41071,41490,41642,42484,43174,43716,44448,46232,47757,48839,49424,49951,49993,50891,52434,52632,52905,53123,53458,54335,54887,54928,55079,56492,57102,57234,58188,59665,60444,60478,60544,60936,61331,63345,63812,64857,65266,65875,65940,66017,66675,67740,68429,68603,68743,68803,69432,70206,70313,70504,71617,72763,73262,76063,77210,77896,78940,79172,80420,80452,80674,80702,81925,82177,82613,83962,84311,84625,85567,85853,87643,87835,90151,90550,90936,92369,92611,92872,93451,94136,94852,95764,96095,96780,96955,98540,98689,100217,100975,100982,101019,101568,101927,101979,102497,103529,104639,104653,104902,105070,106306,107713,108652,108821,109341,109666,109684,109875,110867,112671,112807,113037,114225,114348,115355,116143,116766,117172,117516,117725,118594,118854,119034,119698,120161,120348,120930,121336,121717,121750,124005,124222,124638,124923,125071,125171,128668,129283,131425,131449,131895,132081,132517,133688,133764,133893,134107,134475,135995,136957,137580,138210,138402,138937,138982,139018,139076,139472,140266,140372,140985,141657,141808,142120,142230,142422,142632,143571,145244,145508,145851,146325,147321,147576,148604,149496,150041,150970,151759,152192,152302,153174,153506,153820,153946,154009,154280,154339,155073,155377,156054,157565,161196,162389,164479,164530,164864,165424,165885,165894,166447,166531,168869,169566,169675,170407,170640,171576,172178,172388,175317,176136,176985,177440,179922,180408,180935,182651,183770,185553,186915,187145,188114,188506,189232,189428,190327,190847,191631,192194,193576,193870,194733,194735,194993,195827,196530,197017,198068,198460,198549,
查询(仅范围) 20000 总耗时:312679.133000 毫秒
查询条件:box[(-135.672027,86.248054)-(-134.686173,87.233909)],744824284<=dtime<=1996397776575995,sat=4
查询结果(仅输出ID)：3298,9719,9805,10564,11062,12883,17244,28751,31784,37302,40694,41490,41642,52434,54887,54928,59665,60444,60936,67740,68429,68803,69432,70313,72763,73262,81925,82177,90550,90936,92872,101019,101568,101927,104902,105070,115355,116766,117725,125171,142230,145851,152192,152302,156054,164479,172178,179922,198068,
查询(全条件) 20000 总耗时:312105.731000 毫秒
EEEEEEEEEEEEEEEE----TestRun(query(200000)) 耗时624851.288000----EEEEEEEE