?????????е??????????gogo?????????????
????1?????а汾???
????????????????????????????????????ó???????????????????????????κθ???????????gogo???汾?У????????????????API????????servlet?м????????????????Χ??????ID???????SQL?????????postgresql?ж???????????????????
????SQL??????￡?
Select regionno from sztable.hotregioninfo where dayofweek=’”+ dayofweek+”’ and hour = ‘”+hour+”’ and regionno in “+sBuilder.toString()+”order by amount desc limit ”+return_region_num+”;
???????????????XGO API?????п?????
????????????????????????????800??W??????SQL???????????????2~3?????Ч????￡?????????????????????????Redis????????????????
????2?????????postgresql?Redis
????Redis????????????????????????????????????????????N????????Redis??????????????????“????????”????????key?????У?7*24=168????????????????????????????????????value?е?memeber??score??
??????????????????postgresql?е???redis:?????????PostToRedis?У?ToRedis???????????????м?????????postgresql????1???????????redis????????????????????????????????java???????????????????????????????????Xms????
????3?????????
?????????????????????????????????????????????????serrvlet?м????????????????????????????????????Χ?????е?????ID????д??Redis??????T1????????????β????Ч???????????????ü?????????У????T1???????????168??key??value????????ε??????????Eg?????????????????????????key?3??10????????????????????????????У????N??????????????????????????????????????????????
????????????????β????redis?????????key??????β?????????????????????????????????????????????key???????????????????????1?????Чkey??????????????????????????
???????????????API????????HotRegionRedis?С?
????4????????
??????β???????redis??д???μ????????????redis????????п????10W??д??????????????д???ж??????????????????Redis????????????????????????????????????????????
????5??????
???????????????????з???????????????Geohash??????????????N?????????????????????Redis??д?????????