注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

阿弥陀佛

街树飘影未见尘 潭月潜水了无声 般若观照心空静...

 
 
 

日志

 
 
关于我

一直从事气象预报、服务建模实践应用。 注重气象物理场、实况场、地理信息、本体知识库、分布式气象内容管理系统建立。 对Barnes客观分析, 小波,计算神经网络、信任传播、贝叶斯推理、专家系统、网络本体语言有一定体会。 一直使用Java、Delphi、Prolog、SQL编程。

网易考拉推荐

初始尺度设定为1km时,云南+四川(232)县客观分析花费时间测试  

2014-06-13 09:21:59|  分类: DOC |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

测试结论:
与设想的非常吻合,这次计算时间由上次的1196秒,缩减为98秒,节省时间达到2个数量级。

获取加密站+国家站测站字典....
       select V01000 as c0_sta,V01000 as c1_nm,V05001 as c2_lat,V06001 as c3_lon,V07001 as c4_hgh from OBSERVE.ELE_AWST_SERVICE where to_number(C_BJTIME)=20140612090000 order by V01000
    
6779
取最近24小时最高最低温度记录---
       select V01000 as sta,
              min(V12001) as tmin, max(V12001) as tmax, sum(V13019) as r24
       from OBSERVE.ELE_AWST_SERVICE
       where to_number(C_BJTIME)>20140611090000 and to_number(C_BJTIME)<=20140612090000 and
             V12001 < 999999.0 and V13019 < 999999.0
       group by V01000
    
39480
取最近1小时记录---
       select C_BJTIME,V01000 as sta,V12001 as c00_t,0 as c01_tmin,0 as c02_tmax,V13019 as c03_r1,V13021 as c04_r6,V13022 as c05_r12,V13023 as c06_r24 from OBSERVE.ELE_AWST_SERVICE
       where to_number(C_BJTIME)=20140612090000
       order by V01000
    
6779
20140612090000,记录数6779
numRecords:6779
0,bs_cn,nrow:601,nCol:479,scale:0.45596166094235824,take:1346ms,
1,bs_ll,nrow:574,nCol:601,scale:0.40163787361012204,take:414ms,
2,bs_ly,nrow:601,nCol:559,scale:0.48544475559667455,take:549ms,
3,bs_sd,nrow:601,nCol:408,scale:0.38077232284036333,take:337ms,
4,bs_tc,nrow:601,nCol:334,scale:0.7228145213858871,take:285ms,
5,cx_cx,nrow:479,nCol:601,scale:0.4409608334833785,take:453ms,
6,cx_dy,nrow:601,nCol:547,scale:0.5429836625197157,take:456ms,
7,cx_lf,nrow:505,nCol:601,scale:0.3356974139028149,take:485ms,
8,cx_md,nrow:595,nCol:601,scale:0.0,take:224ms,
9,cx_nh,nrow:601,nCol:597,scale:0.4154185763818446,take:433ms,
10,cx_sb,nrow:428,nCol:601,scale:0.46456088009267515,take:372ms,
11,cx_wd,nrow:601,nCol:396,scale:0.5609309162049908,take:417ms,
12,cx_ya,nrow:412,nCol:601,scale:0.3444789341931488,take:336ms,
13,cx_ym,nrow:601,nCol:411,scale:0.42285647735183257,take:450ms,
14,cx_yr,nrow:601,nCol:472,scale:0.3906631162847936,take:374ms,
15,dh_lc,nrow:494,nCol:601,scale:0.40493103307279626,take:275ms,
16,dh_lh,nrow:586,nCol:601,scale:0.0,take:149ms,
17,dh_ms,nrow:499,nCol:601,scale:0.4430551786505424,take:369ms,
18,dh_rl,nrow:395,nCol:601,scale:0.0,take:83ms,
19,dh_yj,nrow:601,nCol:476,scale:0.5785175581083306,take:314ms,
20,dl_bc,nrow:584,nCol:601,scale:0.47642220456481177,take:508ms,
21,dl_dl,nrow:601,nCol:508,scale:0.0,take:148ms,
22,dl_ey,nrow:462,nCol:601,scale:0.3451834472411744,take:316ms,
23,dl_hq,nrow:601,nCol:370,scale:0.4258475019712956,take:304ms,
24,dl_jc,nrow:503,nCol:601,scale:0.0,take:134ms,
25,dl_md,nrow:601,nCol:365,scale:0.33969739025340623,take:224ms,
26,dl_nj,nrow:525,nCol:601,scale:0.0,take:99ms,
27,dl_ws,nrow:601,nCol:490,scale:0.3947722955588079,take:404ms,
28,dl_xy,nrow:601,nCol:543,scale:0.3909787227319897,take:474ms,
29,dl_yb,nrow:601,nCol:447,scale:0.422947321208081,take:315ms,
30,dl_yl,nrow:601,nCol:591,scale:0.42028956650448984,take:344ms,
31,dl_yp,nrow:601,nCol:562,scale:0.4336004190012168,take:434ms,
32,dq_dq,nrow:601,nCol:331,scale:0.5539285244080541,take:210ms,
33,dq_wx,nrow:601,nCol:417,scale:0.5129888489535612,take:222ms,
34,dq_xg,nrow:601,nCol:287,scale:0.505547368884875,take:308ms,
35,hh_gj,nrow:601,nCol:539,scale:0.3080587095825039,take:309ms,
36,hh_hh,nrow:260,nCol:601,scale:0.4353445010715978,take:275ms,
37,hh_hk,nrow:355,nCol:601,scale:0.37843096864241976,take:159ms,
38,hh_jp,nrow:350,nCol:601,scale:0.48888716749499755,take:229ms,
39,hh_js,nrow:601,nCol:369,scale:0.32522869415312167,take:316ms,
40,hh_ky,nrow:435,nCol:601,scale:0.464743954165179,take:399ms,
41,hh_lc,nrow:402,nCol:601,scale:0.45375866396935993,take:510ms,
42,hh_lx,nrow:571,nCol:601,scale:0.0,take:153ms,
43,hh_ml,nrow:601,nCol:549,scale:0.4511824046927229,take:501ms,
44,hh_mz,nrow:539,nCol:601,scale:0.43527998269083124,take:434ms,
45,hh_pb,nrow:601,nCol:583,scale:0.0,take:104ms,
46,hh_sp,nrow:601,nCol:434,scale:0.2940683628550036,take:373ms,
47,hh_yy,nrow:376,nCol:601,scale:0.3888939406160917,take:353ms,
48,km_an,nrow:601,nCol:469,scale:0.0,take:106ms,
49,km_cg,nrow:544,nCol:601,scale:0.0,take:142ms,
50,km_dc,nrow:601,nCol:420,scale:0.41897524207727205,take:296ms,
51,km_fm,nrow:601,nCol:576,scale:0.0,take:135ms,
52,km_jn,nrow:382,nCol:601,scale:0.2629296849578698,take:315ms,
53,km_lq,nrow:601,nCol:442,scale:0.5627752627251703,take:396ms,
54,km_sl,nrow:601,nCol:567,scale:0.0,take:144ms,
55,km_sm,nrow:352,nCol:601,scale:0.3145867962459828,take:382ms,
56,km_sxq,nrow:601,nCol:568,scale:0.0,take:113ms,
57,km_xd,nrow:480,nCol:601,scale:0.4588029363843133,take:420ms,
58,km_yl,nrow:601,nCol:389,scale:0.31508664903272215,take:315ms,
59,ab_mx,nrow:414,nCol:601,scale:0.545430743158988,take:278ms,
60,ab_reg,nrow:528,nCol:601,scale:0.6590770747963346,take:346ms,
61,ab_rt,nrow:601,nCol:474,scale:0.7190511300960654,take:294ms,
62,ab_sp,nrow:387,nCol:601,scale:0.568099593623591,take:241ms,
63,ab_wc,nrow:601,nCol:552,scale:0.5560286374685286,take:448ms,
64,ab_xj,nrow:601,nCol:509,scale:0.5521273359832246,take:315ms,
65,bz_bz,nrow:438,nCol:601,scale:0.35968376936308133,take:410ms,
66,bz_nj,nrow:601,nCol:470,scale:0.39371296460030486,take:348ms,
67,bz_pc,nrow:504,nCol:601,scale:0.38210297845357716,take:893ms,
68,bz_tj,nrow:601,nCol:519,scale:0.5472003227478819,take:662ms,
69,cd_ch,nrow:480,nCol:601,scale:0.0,take:93ms,
70,cd_cz,nrow:327,nCol:601,scale:0.4458443136472945,take:273ms,
71,cd_djy,nrow:601,nCol:344,scale:0.2682057659613081,take:286ms,
72,cd_dy,nrow:316,nCol:601,scale:0.49505169513815195,take:374ms,
73,cd_jn,nrow:445,nCol:601,scale:0.0,take:152ms,
74,cd_jt,nrow:509,nCol:601,scale:0.0,take:102ms,
75,cd_lqy,nrow:504,nCol:601,scale:0.0,take:172ms,
76,cd_pj,nrow:384,nCol:601,scale:0.0,take:87ms,
77,cd_px,nrow:437,nCol:601,scale:0.0,take:93ms,
78,cd_pz,nrow:601,nCol:564,scale:0.0,take:112ms,
79,cd_qbj,nrow:460,nCol:601,scale:0.0,take:94ms,
80,cd_ql,nrow:296,nCol:601,scale:0.3098958965649382,take:318ms,
81,cd_qy,nrow:238,nCol:601,scale:0.0,take:59ms,
82,cd_sl,nrow:554,nCol:601,scale:0.0,take:139ms,
83,cd_wh,nrow:483,nCol:601,scale:0.0,take:105ms,
84,cd_wj,nrow:601,nCol:567,scale:0.0,take:106ms,
85,cd_xd,nrow:459,nCol:601,scale:0.0,take:90ms,
86,cd_xj,nrow:522,nCol:601,scale:0.0,take:162ms,
87,dy_gh,nrow:393,nCol:601,scale:0.0,take:158ms,
88,dy_jy,nrow:592,nCol:601,scale:0.0,take:198ms,
89,dy_lj,nrow:378,nCol:601,scale:0.0,take:145ms,
90,dy_mz,nrow:601,nCol:481,scale:0.0,take:109ms,
91,dy_sf,nrow:601,nCol:495,scale:0.0,take:125ms,
92,dy_zj,nrow:601,nCol:579,scale:0.42421259704690095,take:677ms,
93,dz_dx,nrow:525,nCol:601,scale:0.3835341881125303,take:2643ms,
94,dz_dz,nrow:601,nCol:494,scale:0.2691534446511632,take:3359ms,
95,dz_kj,nrow:601,nCol:497,scale:0.0,take:156ms,
96,dz_qx,nrow:601,nCol:575,scale:0.38233207996261837,take:3295ms,
97,dz_tc,nrow:588,nCol:601,scale:0.0,take:134ms,
98,dz_wy,nrow:404,nCol:601,scale:0.4534341156271162,take:1363ms,
99,dz_xh,nrow:366,nCol:601,scale:0.3924502770525073,take:2265ms,
100,ga_ga,nrow:594,nCol:601,scale:0.0,take:129ms,
101,ga_hy,nrow:601,nCol:514,scale:0.0,take:113ms,
102,ga_ls,nrow:513,nCol:601,scale:0.2528405021617781,take:8178ms,
103,ga_ws,nrow:427,nCol:601,scale:0.0,take:111ms,
104,ga_yc,nrow:534,nCol:601,scale:0.26713554425503094,take:4422ms,
105,gy_ct,nrow:369,nCol:601,scale:0.39682530882089306,take:266ms,
106,gy_cx,nrow:450,nCol:601,scale:0.36488142607941076,take:382ms,
107,gy_jg,nrow:601,nCol:471,scale:0.41303656749058737,take:450ms,
108,gy_lz,nrow:292,nCol:601,scale:0.338203372988086,take:191ms,
109,gy_qc,nrow:470,nCol:601,scale:0.43782198418833185,take:251ms,
110,gy_wc,nrow:543,nCol:601,scale:0.3948015681012053,take:378ms,
111,gy_yb,nrow:560,nCol:601,scale:0.0,take:104ms,
112,gz_bt,nrow:601,nCol:292,scale:0.7477513019918406,take:197ms,
113,gz_by,nrow:578,nCol:601,scale:0.8309550970929169,take:391ms,
114,gz_db,nrow:601,nCol:557,scale:0.5607196422619164,take:332ms,
115,gz_dc,nrow:601,nCol:263,scale:0.6077024751929536,take:199ms,
116,gz_df,nrow:601,nCol:587,scale:0.6085522610142574,take:307ms,
117,gz_dg,nrow:550,nCol:601,scale:1.106326005820649,take:303ms,
118,gz_dr,nrow:601,nCol:274,scale:0.4818247535409424,take:214ms,
119,gz_gz,nrow:601,nCol:498,scale:1.2086006063063568,take:241ms,
120,gz_jl,nrow:575,nCol:601,scale:0.5868345761677551,take:508ms,
121,gz_kd,nrow:601,nCol:547,scale:0.6241785168608206,take:330ms,
122,gz_ld,nrow:601,nCol:500,scale:0.29275854565175385,take:382ms,
123,gz_lh,nrow:576,nCol:601,scale:0.468512865556297,take:349ms,
124,gz_lt,nrow:601,nCol:546,scale:0.7738341219784086,take:293ms,
125,gz_sd,nrow:495,nCol:601,scale:1.0057371686961079,take:221ms,
126,gz_sq,nrow:531,nCol:601,scale:1.1117140890239392,take:368ms,
127,gz_xc,nrow:601,nCol:389,scale:0.6943791472814008,take:310ms,
128,gz_xl,nrow:535,nCol:601,scale:0.622503464089548,take:292ms,
129,gz_yj,nrow:601,nCol:457,scale:0.6846163052044029,take:225ms,
130,les_eb,nrow:587,nCol:601,scale:0.39303294612513,take:468ms,
131,les_ems,nrow:601,nCol:596,scale:0.0,take:111ms,
132,les_jj,nrow:396,nCol:601,scale:0.0,take:104ms,
133,les_jkh,nrow:601,nCol:483,scale:0.0,take:98ms,
134,les_jw,nrow:536,nCol:601,scale:0.0,take:128ms,
135,les_jy,nrow:601,nCol:510,scale:0.0,take:271ms,
136,les_mb,nrow:601,nCol:558,scale:0.3226957530599522,take:460ms,
137,les_mc,nrow:511,nCol:601,scale:0.0,take:103ms,
138,les_sw,nrow:601,nCol:578,scale:0.0,take:113ms,
139,les_szq,nrow:393,nCol:601,scale:0.0,take:96ms,
140,les_wtq,nrow:505,nCol:601,scale:0.0,take:100ms,
141,ls_bt,nrow:601,nCol:322,scale:0.35845691450246825,take:297ms,
142,ls_dc,nrow:530,nCol:601,scale:0.0,take:102ms,
143,ls_gl,nrow:601,nCol:515,scale:0.34237105440238313,take:413ms,
144,ls_hd,nrow:601,nCol:595,scale:0.4521213656852183,take:487ms,
145,ls_hl,nrow:601,nCol:421,scale:0.5098556570941314,take:323ms,
146,ls_jy,nrow:601,nCol:572,scale:0.0,take:128ms,
147,ls_lb,nrow:601,nCol:533,scale:0.34708375614273934,take:415ms,
148,ls_mg,nrow:601,nCol:352,scale:0.412839706401707,take:316ms,
149,ls_ml,nrow:560,nCol:601,scale:0.6725395448980357,take:353ms,
150,ls_mn,nrow:601,nCol:497,scale:0.5592662235517696,take:456ms,
151,ls_nn,nrow:601,nCol:579,scale:0.0,take:132ms,
152,ls_pg,nrow:601,nCol:404,scale:0.31464294296424317,take:351ms,
153,ls_xc,nrow:594,nCol:601,scale:0.5311684452788399,take:429ms,
154,ls_xd,nrow:601,nCol:490,scale:0.30332615137388663,take:356ms,
155,ls_yx,nrow:601,nCol:595,scale:0.0,take:117ms,
156,ls_yy,nrow:515,nCol:601,scale:0.5666712366512419,take:366ms,
157,ls_zj,nrow:375,nCol:601,scale:0.34528784196769646,take:327ms,
158,lz_gl,nrow:507,nCol:601,scale:0.37682140194434255,take:1000ms,
159,lz_hj,nrow:393,nCol:601,scale:0.25110451407636325,take:3418ms,
160,lz_jy,nrow:273,nCol:601,scale:0.0,take:65ms,
161,lz_lmt,nrow:412,nCol:601,scale:0.0,take:84ms,
162,lz_lx,nrow:438,nCol:601,scale:0.0,take:86ms,
163,lz_nx,nrow:522,nCol:601,scale:0.0,take:103ms,
164,lz_xy,nrow:601,nCol:390,scale:0.4154904702948835,take:672ms,
165,ms_dl,nrow:458,nCol:601,scale:0.0,take:172ms,
166,ms_dp,nrow:495,nCol:601,scale:0.0,take:173ms,
167,ms_hy,nrow:514,nCol:601,scale:0.36017570824544803,take:423ms,
168,ms_ps,nrow:523,nCol:601,scale:0.0,take:98ms,
169,ms_qs,nrow:424,nCol:601,scale:0.0,take:85ms,
170,ms_rs,nrow:601,nCol:502,scale:0.3594257581035076,take:602ms,
171,my_ax,nrow:467,nCol:601,scale:0.0,take:103ms,
172,my_bc,nrow:326,nCol:601,scale:0.5092754732823064,take:264ms,
173,my_fc,nrow:555,nCol:601,scale:0.0,take:120ms,
174,my_jy,nrow:601,nCol:595,scale:0.46687726041140337,take:421ms,
175,my_pw,nrow:552,nCol:601,scale:0.5391195319714996,take:352ms,
176,my_st,nrow:601,nCol:479,scale:0.3281596122938451,take:666ms,
177,my_yt,nrow:592,nCol:601,scale:0.0,take:109ms,
178,my_yx,nrow:505,nCol:601,scale:0.0,take:110ms,
179,my_zt,nrow:571,nCol:601,scale:0.0,take:105ms,
180,nc_gp,nrow:555,nCol:601,scale:0.0,take:104ms,
181,nc_jl,nrow:601,nCol:530,scale:0.0,take:142ms,
182,nc_lz,nrow:400,nCol:601,scale:0.32492687815354165,take:404ms,
183,nc_nb,nrow:343,nCol:601,scale:0.3936644781967536,take:376ms,
184,nc_pa,nrow:601,nCol:569,scale:0.0,take:118ms,
185,nc_sq,nrow:601,nCol:560,scale:0.0,take:111ms,
186,nc_xc,nrow:496,nCol:601,scale:0.0,take:98ms,
187,nc_yl,nrow:436,nCol:601,scale:0.3817431925490157,take:509ms,
188,nc_ys,nrow:557,nCol:601,scale:0.0,take:110ms,
189,nj_dx,nrow:435,nCol:601,scale:0.0,take:106ms,
190,nj_lc,nrow:523,nCol:601,scale:0.0,take:139ms,
191,nj_szq,nrow:601,nCol:544,scale:0.0,take:245ms,
192,nj_wy,nrow:432,nCol:601,scale:0.33759868240381175,take:676ms,
193,nj_zz,nrow:427,nCol:601,scale:0.3451249276885085,take:1439ms,
194,pzh_dq,nrow:553,nCol:601,scale:0.0,take:107ms,
195,pzh_my,nrow:601,nCol:522,scale:0.3739247299030867,take:378ms,
196,pzh_rh,nrow:601,nCol:467,scale:0.30371770544339133,take:280ms,
197,pzh_xq,nrow:369,nCol:601,scale:0.0,take:78ms,
198,pzh_yb,nrow:601,nCol:596,scale:0.4475232370275819,take:321ms,
199,sn_aj,nrow:360,nCol:601,scale:0.2879022532915696,take:2124ms,
200,sn_cs,nrow:540,nCol:601,scale:0.0,take:114ms,
201,sn_dy,nrow:423,nCol:601,scale:0.0,take:89ms,
202,sn_px,nrow:598,nCol:601,scale:0.0,take:150ms,
203,sn_sh,nrow:601,nCol:554,scale:0.0,take:246ms,
204,ya_bx,nrow:601,nCol:479,scale:0.5277029678964504,take:492ms,
205,ya_hy,nrow:520,nCol:601,scale:0.3631077618152709,take:487ms,
206,ya_ls,nrow:601,nCol:258,scale:0.45444958596959395,take:218ms,
207,ya_ms,nrow:507,nCol:601,scale:0.0,take:137ms,
208,ya_sm,nrow:601,nCol:558,scale:0.3734116815339202,take:438ms,
209,ya_tq,nrow:495,nCol:601,scale:0.4190620346593186,take:469ms,
210,ya_yc,nrow:601,nCol:370,scale:0.0,take:91ms,
211,ya_yj,nrow:458,nCol:601,scale:0.36366233359214983,take:389ms,
212,yb_cn,nrow:601,nCol:367,scale:0.0,take:75ms,
213,yb_cp,nrow:576,nCol:601,scale:0.0,take:110ms,
214,yb_gaox,nrow:601,nCol:503,scale:0.0,take:97ms,
215,yb_gx,nrow:601,nCol:416,scale:0.32108416707488857,take:329ms,
216,yb_ja,nrow:601,nCol:289,scale:0.0,take:78ms,
217,yb_jl,nrow:479,nCol:601,scale:0.0,take:95ms,
218,yb_nx,nrow:601,nCol:589,scale:0.0,take:117ms,
219,yb_ps,nrow:295,nCol:601,scale:0.2786396326682642,take:355ms,
220,yb_xw,nrow:484,nCol:601,scale:0.0,take:353ms,
221,yb_yb,nrow:601,nCol:451,scale:0.3910350368669215,take:414ms,
222,zg_da,nrow:332,nCol:601,scale:0.0,take:76ms,
223,zg_fs,nrow:572,nCol:601,scale:0.0,take:130ms,
224,zg_gj,nrow:601,nCol:559,scale:0.0,take:105ms,
225,zg_rx,nrow:482,nCol:601,scale:0.3076897894126556,take:588ms,
226,zg_yt,nrow:401,nCol:601,scale:0.0,take:127ms,
227,zg_zlj,nrow:358,nCol:601,scale:0.0,take:101ms,
228,zy_ay,nrow:477,nCol:601,scale:0.30803050859724873,take:3750ms,
229,zy_jy,nrow:473,nCol:601,scale:0.3078188544947248,take:737ms,
230,zy_lz,nrow:601,nCol:495,scale:0.0,take:151ms,
231,zy_yj,nrow:445,nCol:601,scale:0.28384684263582366,take:1099ms,
sum time:98283.0 mean :423.6336206896552
  评论这张
 
阅读(486)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017