涓銆?a target="_blank">FastUnit騫沖彴鐨勫垎欏墊満鍒?/strong>
浣跨敤2嬈℃煡璇㈡潵瀹炵幇鍒嗛〉錛?br />
1. 鑾峰彇鎬昏褰曟暟
select count ( * ) from T where 
2. 鍒╃敤Oracle鐨剅ownum鑾峰彇鎸囧畾欏電殑鏁版嵁
select * from ( select row_. * , rownum rownum_ from ( SELECT * FROM T where ) row_ where rownum <= ?) where rownum_ > ? 錛堟牴鎹笂涓姝ュ緱鍒扮殑鎬昏褰曟暟浠ュ強姣忛〉琛屾暟銆佸綋鍓嶉〉鐮佽綆楀嚭璧峰琛屽彿鍜岀粨鏉熻鍙鳳紝璁劇疆鍦ㄤ笂榪癝QL璇彞鐨?#8220;錛?#8221;澶勶級
浜屻佹祴璇曠幆澧?/strong>
鎿嶄綔緋葷粺錛歐indows XP Professional SP1
CPU錛氳繀椹?.6G
鐗╃悊鍐呭瓨錛?G
搴旂敤鏈嶅姟鍣細Tomcat 5.5.23
鏁版嵁搴擄細Oracle92錛堥粯璁よ緗級
涓夈佹祴璇曞璞?/strong>
FastUnit騫沖彴鐨勬棩蹇楄〃錛岃剼鏈涓嬶細
CREATE TABLE ACCESSLOG( id NUMBER ( 10 , 0 ) NOT NULL , type NUMBER ( 1 , 0 ), userid VARCHAR2 ( 50 ), username VARCHAR2 ( 50 ), org VARCHAR2 ( 50 ), domain VARCHAR2 ( 50 ), groupid VARCHAR2 ( 50 ), groupname VARCHAR2 ( 50 ), unitid VARCHAR2 ( 50 ), unitname VARCHAR2 ( 50 ), elementid VARCHAR2 ( 50 ), elementname VARCHAR2 ( 50 ), cost NUMBER ( 5 , 0 ), ok NUMBER ( 1 , 0 ), curtime DATE, PRIMARY KEY (id)); CREATE INDEX AL_ct_idx on ACCESSLOG (curtime);
鍥涖佹祴璇曠粨鏋?/strong>
鏈渚嬩腑錛屾暟鎹簱闄や簡绱㈠紩鏈嬌鐢ㄥ叾浠栦紭鍖栨帾鏂姐?br />
浠呰緗甤urtime鏉′歡鏃訛紙浣跨敤绱㈠紩錛夛紝騫沖潎鍝嶅簲鏃墮棿涓?20姣錛堝涓嬪浘鎵紺猴級錛?br />
瀵規瘮錛?br />
涓嶈緗換浣曟潯浠舵椂錛屽鉤鍧囧搷搴旀椂闂翠負2300姣錛?br />
浠呰緗畊serid鏉′歡鏃訛紙鏈嬌鐢ㄧ儲寮曪級錛屽鉤鍧囧搷搴旀椂闂翠負5100姣銆?br />
錛堝浘涓殑嫻嬭瘯鏁版嵁鐢盕astUnit鐨勮窡韙櫒緇熻鐨勶紝鐢ㄦ潵璺熻釜榪涚▼鍐呭悇鏂偣涔嬮棿鏃墮棿娑堣椼佹暟鎹簱榪炴帴鏁般佹煡璇㈡鏁般佸鍒犳敼嬈℃暟銆佸唴瀛樻秷鑰楃瓑錛屽彲浠ョ洿瑙傜殑鍒ゆ柇鍑虹郴緇熺摱棰堢殑浣嶇疆錛屼負緋葷粺浼樺寲鎻愪緵鏀寔銆傦級
浜斻佸浜庡ぇ琛ㄧ殑涓鑸т紭鍖栨帾鏂?/strong>
1. 琛ㄧ粨鏋勮璁″師鍒欙細鏁版嵁綾誨瀷灝介噺灝忥紙鍗犵敤絀洪棿灝戯紝紓佺洏璇誨叆杈冨揩錛夈佸崟鐙緗〃絀洪棿
2. 搴旂敤紼嬪簭錛氬悎鐞嗚璁′笟鍔°丼QL璇彞浼樺寲
3. 鍚堢悊浣跨敤绱㈠紩錛氬彧鍒涘緩闇瑕佺殑绱㈠紩錛屾牴鎹渶瑕佷嬌鐢ㄥ鍒楃儲寮曪紝瀛樻斁浜庡崟鐙殑琛ㄧ┖闂?br />
4. 鏁版嵁搴撹緗細鍐呭瓨鍒嗛厤銆佹煡璇紭鍖栧櫒銆佸垎鍖恒佸垎琛ㄧ瓑
5. 紜歡鐜錛氱‖鐩樸丆PU銆佸唴瀛樸佺綉緇滃甫瀹?/p>
]]>