锘??xml version="1.0" encoding="utf-8" standalone="yes"?> 銆銆 瀵逛簬寮鍙戝浜庨〉闈㈣繛鎺ュ挨濡傝湗铔涚綉涓鏍鳳紝緇忓父浼氭湁涓鍫嗗叿鏈夊崈澶翠竾緇殑鍏寵仈欏甸潰緇勬垚鐨勫ぇ涓瀷Web搴旂敤鏉ヨ錛屽浣曠粍緇囧強澶勭悊欏甸潰鐨勮煩杞垚涓轟竴涓狹VC妗嗘灦闈炲父鍏抽敭鍥犵礌銆係truts1涔嬫墍浠ヨ兘寰楀埌澶у鐨勮鍙紝鏄洜涓轟粬鍩烘湰瑙e喅浜嗘暟鎹笌瑙嗗浘鍒嗙鐨勯棶棰橈紝涔嬫墍浠truts鍗囩駭涓涓増鏈埌Struts2鍚庝笉鍐?#8220;Struts”浜嗭紝鏍稿績鍘熷洜闄や簡妗嗘灦鏍稿績鎶鏈惤鍚庛佸緢澶氬湴鏂瑰彈闄愬埗浠ュ錛屼竴涓師鍥犳槸浠栨棤娉曞緢濂藉湴緇勭粐鍙婂鐞嗛〉闈㈣煩杞棶棰樸傚綋鐒跺敖綆″崌綰у埌浜哠truts2錛屼絾鐩稿浜嶳ails絳夋柊鍏碝VC鐨勬鏋舵潵璇達紝鏄懼緱姝繪澘浜嗗緢澶氥?br />
銆銆鑰孍asyJWeb鍦ㄩ〉闈㈢粍緇囧強澶勭悊欏甸潰璺寵漿絳夋柟闈紝鎻愪緵浜嗗緢澶氭洿鍔犵伒媧葷殑鍔熻兘錛屽緢澶氭濇兂鏉ヨ嚜浜嶴pring MVC銆丷ails絳変竴浜涙柊鍏碬eb妗嗘灦鐨勭簿楂擄紝浠栬兘璁╀綘鐢ㄦ瘮杈冪畝媧佺殑浠g爜銆佺敋鑷充笉鐢ㄤ唬鐮佹潵瀹炵幇欏甸潰鐨勮煩杞?br />
銆銆鍦╓eb搴旂敤紼嬪簭寮鍙戜腑錛屾垜浠粡甯擱亣鍒板涓嬬殑闇姹傦細 銆銆 鍙互璇達紝鐜板湪寰堝皯鏈夋鏋惰兘瀹屽叏婊¤凍鎴栬呬負鐢ㄦ埛鑰冭檻鍒板姝ゅ鏉傚鍙樿屽浜庢垜浠浗浜烘潵璇村簲鐢ㄦу張闈炲父騫挎硾鐨勯渶姹傘備竴浜涙鏋跺嵆浣挎彁渚涗笂闈竴浜涘姛鑳戒篃鏄互涔﹀啓澶嶆潅鐨勪唬鐮佸強閰嶇疆鏂囦歡涓轟唬浠風殑銆傚湪EasyJWeb涓紝鎻愪緵浜嗕笂闈㈡墍鍒楃殑榪欎簺鍔熻兘錛屽茍鎻愪緵浜嗛潪甯哥畝媧佺殑璋冪敤鎺ュ彛鍙婃柟娉曘?br />
銆銆 閽堝涓婇潰鐨勫嚑鐐癸紝EasyJWeb鐨勮В鍐蟲柟妗堬細
銆銆1銆佷粠榪欎釜欏甸潰榪炴帴鍒板彟澶栦竴涓〉闈紱
銆銆2銆佸湪鏈嶅姟鍣ㄦ墽琛屽畬鏌愪竴孌電▼搴忓悗錛屾妸杈撳嚭瀵煎悜鍙﹀涓涓〉闈紱
銆銆3銆佸湪鏈嶅姟鍣ㄧ鎵ц瀹屾煇涓孌電▼搴忓悗錛屾妸杈撳嚭瀵煎悜鍒板彟澶栦竴孌電▼搴忕戶緇墽琛岋紱
銆銆4銆佸湪鏈嶅姟鍣ㄧ▼搴忔墽琛屽畬鍚庯紝閫夋嫨浣跨敤涓涓〉闈㈠憟鐜扮敤鎴瘋緭鍑猴紱
銆銆5銆侀〉闈㈣煩杞鍏鋒湁杈冨己鐨勭幆澧冮傚簲鑳藉姏錛屾瘮濡傞儴緗插湪璺熺洰褰曚笅璺熼儴緗插埌鍏跺畠Context鐩綍涓嬮兘鑳芥墽琛屾紜殑璺寵漿錛?br />
銆銆6銆佽繕鏈夋洿鍙樻佺殑錛屾瘮濡侲asyJF瀹樼綉錛岃姹備嬌鐢?a target="_blank">鍔ㄦ佸湴鍧璁塊棶鐨勬椂鍊欙紝鐪嬪埌鐨勫湴鍧鍏ㄦ槸鍔ㄦ侊紝褰撲嬌鐢?a target="_blank">闈欐佸湴鍧璁塊棶鐨勬椂鍊欙紝鍦板潃鍏ㄦ槸闈欐佺殑錛孞ava Web鏈嶅姟鍣ㄤ笉鑳藉伐浣滀簡錛孉pache鎴朓IS涔熻淇濊瘉緗戦〉鑳芥甯歌闂?br />
銆銆7銆佹湁鐨勪漢鍠滄浣跨敤/user/edit/1榪欐牱鐨剈rl錛屾湁鐨勪漢鍠滄浣跨敤/user.ejf?cmd=edit&id=1榪欐牱鐨剈rl錛屾垜浠姹備笉綆′嬌鐢ㄥ摢涓縐島rl鏍峰紡璁塊棶欏甸潰錛岃繛鎺ラ兘浼氶潪甯稿弸濂界殑鍙樻垚鐢ㄦ埛鍠滅埍鐨勫艦寮忋?/p>
銆銆1,榪欎釜鐢?lt;a>鏍囩錛屼笉鐢ㄨ浜嗐?br />
銆銆2銆佸湪鏈嶅姟鍣ㄦ墽琛屽畬鏌愪竴孌電▼搴忓悗錛屾妸杈撳嚭瀵煎悜鍙﹀涓涓〉闈紱
銆銆榪斿洖html綾誨瀷鐨凱age瀵硅薄銆?br />
銆銆3銆佸湪鏈嶅姟鍣ㄧ鎵ц瀹屾煇涓孌電▼搴忓悗錛屾妸杈撳嚭瀵煎悜鍒板彟澶栦竴孌電▼搴忕戶緇墽琛岋紱
銆銆 浣跨敤forward鎴栬単o鏂規硶銆?/strong>
銆銆4銆佸湪鏈嶅姟鍣ㄧ▼搴忔墽琛屽畬鍚庯紝閫夋嫨浣跨敤涓涓〉闈㈠憟鐜扮敤鎴瘋緭鍑猴紱
銆銆 浣跨敤page鏂規硶銆?br />
銆銆5銆侀〉闈㈣煩杞鍏鋒湁杈冨己鐨勭幆澧冮傚簲鑳藉姏錛屾瘮濡傞儴緗插湪璺熺洰褰曚笅璺熼儴緗插埌鍏跺畠Context鐩綍涓嬮兘鑳芥墽琛屾紜殑璺寵漿錛?br />
銆銆鍦ㄩ〉闈㈡ā鏉夸腑浣跨敤$html.url錛屾瘮濡傦細<a href="$html.url('user.list')">鐢ㄦ埛鍒楄〃</a>銆?br />
銆銆6銆佷笉鍚屽湴鍧鏍峰紡杞Щ
銆銆鍦ㄩ〉闈㈡ā鏉夸腑浣跨敤$html.forward錛屾瘮濡?lt;a href="$html. forward'('news.technic')">鎶鏈墠娌?lt;/a>銆傝繖鏍峰姩鎬佺殑鏃跺欒闂埌鐨勬槸news.ejf?cmd= technic錛岄潤鎬佺殑鏃跺欒闂埌鐨勬槸/news/technic.html銆?/strong>
銆銆7銆佷紶緇熷強鐜頒唬鐨刄RL鏍峰紡杞崲
銆銆 浠嶇劧鏄嬌鐢?html.url錛屾垨$html.forward鏍囩錛屼粬鑳芥劅鐭ヤ綘鐨剈rl鏍峰紡銆傛瘮濡傦細<a href="$html.url('user.add')">娣誨姞鐢ㄦ埛</a>銆備綘浣跨敤user.ejf?cmd=lsit,璁塊棶搴旂敤錛屽垯褰撶偣娣誨姞user.ejf?cmd=add銆傝屽鏋滀綘浣跨敤/ejf/user/list璁塊棶搴旂敤錛屽垯緙栬緫鎸夐挳鐨勮繛鎺ュ彉鎴恊jf/user/add銆?br />
銆銆
銆銆鍦ㄤ唬鐮佷腑錛岄櫎浜嗗彲浠ヤ嬌鐢ㄦ渶鍘熷鐨剅eturn new Page()鏂瑰紡榪斿洖鐢ㄦ埛鐨勮鍥炬ā鏉夸互澶栵紝榪樺彲浠ヤ嬌鐢ㄤ竴浜涘揩鎹鋒柟娉曟潵瀹炵幇鐏墊椿鐨勮鍥炬煡璇㈠強璺寵漿銆傛瘮濡傦紝go銆乫orward銆乸age絳夋柟娉曘備笅闈㈢湅涓涓敤鎴鋒坊鍒犳敼鏌ョ殑紺轟緥涓殑Action浠g爜濡備笅錛?br />
import com.easyjf.container.annonation.Inject;
import com.easyjf.core.support.query.QueryObject;
import com.easyjf.util.CommUtil;
import com.easyjf.web.WebForm;
import com.easyjf.web.core.AbstractPageCmdAction;
import com.easyjf.web.tools.IPageList;
public class UserAction extends AbstractPageCmdAction {
@Inject
private UserService service;
public void setService(UserService service) {
this.service = service;
}
/**
* 鏄劇ず娣誨姞鐢ㄦ埛鐨勭晫闈ser/edit.html
*/
public void add()
{
page("edit");
}
public void edit(WebForm form)
{
String id=(String)form.get("id");
User user=this.service.getUser(new Long(id));
form.addPo(user);
}
public void save(WebForm form)
{
User user=form.toPo(User.class);
if(hasErrors())
{
page("edit");
return;
}
service.saveUser(user);
forward("list");
}
public void update(WebForm form)
{
String id=(String)form.get("id");
User user=this.service.getUser(new Long(id));
form.toPo(user,true);
if(hasErrors())
{
page("edit");
return;
}
service.updateUser(user);
forward("list");
}
public void delete(WebForm form)
{
String id=(String)form.get("id");
User user=this.service.getUser(new Long(id));
service.delUser(user);
go("list");
}
public void list(WebForm form)
{
QueryObject qo=form.toPo(QueryObject.class);
IPageList pageList=service.queryUser(qo);
CommUtil.saveIPageList2WebForm(pageList, form);
}
}
UserService鎺ュ彛錛?br />
public interface UserService {
/**
* 鏍規嵁id鏌ヨ鐢ㄦ埛
*
* @param id
* @return
*/
User getUser(Long id);
/**
* 淇濆瓨鐢ㄦ埛
*
* @param user
*/
void saveUser(User user);
/**
* 淇敼鐢ㄦ埛淇℃伅
*
* @param user
*/
void updateUser(User user);
/**
* 鍒犻櫎鐢ㄦ埛
*
* @param user
*/
void delUser(User user);
/**
* 鏌ヨ鐢ㄦ埛淇℃伅
* @param query
* @return 鍒嗛〉淇℃伅鍙婅褰曢泦
*/
IPageList queryUser(IQueryObject query);
}
import java.util.List;
import java.util.Random;
public class PrimeNumberTest {
/** Creates a new instance of PrimeNumberTest */
public PrimeNumberTest() { }
public static void main(String[] args){
//鑾峰緱涓涓?浣嶆暟鐨勯殢鏈哄ぇ绱犳暟
long longVar4 = createRadomPrimeNunber(4);
System.out.println(longVar4);
//鑾峰緱涓涓?浣嶆暟鐨勯殢鏈哄ぇ绱犳暟
long longVar5 = createRadomPrimeNunber(5);
System.out.println(longVar5);
}
public static long createRadomPrimeNunber(int n){
long recLong = 0;
List list = listAllPrimeNumber(n);
Random rd = new Random();
int randomIndex = Math.abs( rd.nextInt()%list.size());
recLong = ((Long)list.get(randomIndex)).longValue();
return recLong;
}
public static List listAllPrimeNumber(int n){
List list = new ArrayList();
long low = (long)Math.pow(10,n-1);
long high = (long)Math.pow(10,n) - 1;
for(long i= low;i < high;i++){
if( isSushu(i)) {
list.add(new Long(i));
} }
return list;
}
public static boolean isSushu(long x){
//瀹氫箟涓涓垽鏂竴涓暟鏄惁鏄礌鏁扮殑鍑芥暟
if(x<2) return false; if( x==2)return true;
for(long i=2;
i<= (long)Math.sqrt(x);i++)
if(x%i==0)
return false;
return true;
}}
import java.util.Random;
/**
* Java瀹炵敤宸ュ叿綾誨簱涓殑綾籮ava.util.Random鎻愪緵浜嗕駭鐢熷悇縐嶇被鍨嬮殢鏈烘暟鐨勬柟娉曘?br />
* 瀹冨彲浠ヤ駭鐢焛nt銆乴ong銆乫loat銆乨ouble浠ュ強Goussian絳夌被鍨嬬殑闅忔満鏁般?br />
* java.lang.Math涓殑鏂規硶random()鍙駭鐢焏ouble鍨嬬殑闅忔満鏁般?br />
*/
public class RandomNumber{
public static void main(String[] args) {
// 浣跨敤java.lang.Math鐨剅andom鏂規硶鐢熸垚闅忔満鏁?br /> System.out.println("Math.random(): " + Math.random());
// 浣跨敤涓嶅甫鍙傛暟鐨勬瀯閫犳柟娉曟瀯閫爅ava.util.Random瀵硅薄
System.out.println("浣跨敤涓嶅甫鍙傛暟鐨勬瀯閫犳柟娉曟瀯閫犵殑Random瀵硅薄:");
Random rd1 = new Random();
// 浜х敓鍚勭綾誨瀷鐨勯殢鏈烘暟
// 鎸夊潎鍖鍒嗗竷浜х敓鏁存暟
System.out.println("int: " + rd1.nextInt());
// 鎸夊潎鍖鍒嗗竷浜х敓闀挎暣鏁?br />
System.out.println("long: " + rd1.nextLong());
// 鎸夊潎鍖鍒嗗竷浜х敓澶т簬絳変簬0錛屽皬浜?鐨刦loat鏁癧0, 1)
System.out.println("float: " + rd1.nextFloat());
// 鎸夊潎鍖鍒嗗竷浜х敓[0, 1)鑼冨洿鐨刣ouble鏁?br />
System.out.println("double: " + rd1.nextDouble());
// 鎸夋鎬佸垎甯冧駭鐢熼殢鏈烘暟
System.out.println("Gaussian: " + rd1.nextGaussian());
// 鐢熸垚涓緋誨垪闅忔満鏁?br />
System.out.print("闅忔満鏁存暟搴忓垪:");
for (int i = 0; i < 5; i++) {
System.out.print(rd1.nextInt() + " ");
}
System.out.println();
// 鎸囧畾闅忔満鏁頒駭鐢熺殑鑼冨洿
System.out.print("[0,10)鑼冨洿鍐呴殢鏈烘暣鏁板簭鍒? ");
for (int i = 0; i < 10; i++) {
// Random鐨刵extInt(int n)鏂規硶榪斿洖涓涓猍0, n)鑼冨洿鍐呯殑闅忔満鏁?br />
System.out.print(rd1.nextInt(10) + " ");
}
System.out.println();
System.out.print("[5,23)鑼冨洿鍐呴殢鏈烘暣鏁板簭鍒? ");
for (int i = 0; i < 10; i++) {
// 鍥犱負nextInt(int n)鏂規硶鐨勮寖鍥存槸浠?寮濮嬬殑錛?br />
// 鎵浠ラ渶瑕佹妸鍖洪棿[5,28)杞崲鎴? + [0, 23)銆?br />
System.out.print(5 + rd1.nextInt(23) + " ");
}
System.out.println();
System.out.print("鍒╃敤nextFloat()鐢熸垚[0,99)鑼冨洿鍐呯殑闅忔満鏁存暟搴忓垪: ");
for (int i = 0; i < 10; i++) {
System.out.print((int) (rd1.nextFloat() * 100) + " ");
}
System.out.println();
System.out.println();
// 浣跨敤甯﹀弬鏁扮殑鏋勯犳柟娉曟瀯閫燫andom瀵硅薄
// 鏋勯犲嚱鏁扮殑鍙傛暟鏄痩ong綾誨瀷錛屾槸鐢熸垚闅忔満鏁扮殑縐嶅瓙銆?br />
System.out.println("浣跨敤甯﹀弬鏁扮殑鏋勯犳柟娉曟瀯閫犵殑Random瀵硅薄:");
Random ran2 = new Random(10);
// 瀵逛簬縐嶅瓙鐩稿悓鐨凴andom瀵硅薄錛岀敓鎴愮殑闅忔満鏁板簭鍒楁槸涓鏍風殑銆?br />
System.out.println("浣跨敤縐嶅瓙涓?0鐨凴andom瀵硅薄鐢熸垚[0,10)鍐呴殢鏈烘暣鏁板簭鍒? ");
for (int i = 0; i < 10; i++) {
System.out.print(ran2.nextInt(10) + " ");
}
System.out.println();
Random ran3 = new Random(10);
System.out.println("浣跨敤鍙︿竴涓瀛愪負10鐨凴andom瀵硅薄鐢熸垚[0,10)鍐呴殢鏈烘暣鏁板簭鍒? ");
for (int i = 0; i < 10; i++) {
System.out.print(ran3.nextInt(10) + " ");
}
System.out.println();
// ran2鍜宺an3鐢熸垚鐨勯殢鏈烘暟搴忓垪鏄竴鏍風殑錛屽鏋滀嬌鐢ㄤ袱涓病甯﹀弬鏁版瀯閫犲嚱鏁扮敓鎴愮殑Random瀵硅薄錛?br />
// 鍒欎笉浼氬嚭鐜拌繖縐嶆儏鍐碉紝榪欐槸鍥犱負鍦ㄦ病甯﹀弬鏁版瀯閫犲嚱鏁扮敓鎴愮殑Random瀵硅薄鐨勭瀛愮己鐪佹槸褰撳墠緋葷粺鏃墮棿鐨勬縐掓暟銆?/p>
// 鍙﹀錛岀洿鎺ヤ嬌鐢≧andom鏃犳硶閬垮厤鐢熸垚閲嶅鐨勬暟瀛楋紝濡傛灉闇瑕佺敓鎴愪笉閲嶅鐨勯殢鏈烘暟搴忓垪錛岄渶瑕佸熷姪鏁扮粍鍜岄泦鍚堢被
//鏈功絎?绔犲皢緇欏嚭瑙e喅鏂規硶銆?br />
}
}
榪愯緇撴灉錛?br />
C:\>java RandomNumber
Math.random(): 0.525171492959965
浣跨敤涓嶅甫鍙傛暟鐨勬瀯閫犳柟娉曟瀯閫犵殑Random瀵硅薄:
int: 636539740
long: -752663949229005813
float: 0.87349784
double: 0.4065973309853902
Gaussian: 0.4505871918488808
闅忔満鏁存暟搴忓垪:1936784917 1339857386 -1185229615 1883411721 1409219372
[0,10)鑼冨洿鍐呴殢鏈烘暣鏁板簭鍒? 1 1 5 5 9 0 1 0 2 4
[5,23)鑼冨洿鍐呴殢鏈烘暣鏁板簭鍒? 9 13 26 18 11 27 26 12 21 8
鍒╃敤nextFloat()鐢熸垚[0,99)鑼冨洿鍐呯殑闅忔満鏁存暟搴忓垪: 1 47 72 59 49 86 80 88 55 82
浣跨敤甯﹀弬鏁扮殑鏋勯犳柟娉曟瀯閫犵殑Random瀵硅薄:
浣跨敤縐嶅瓙涓?0鐨凴andom瀵硅薄鐢熸垚[0,10)鍐呴殢鏈烘暣鏁板簭鍒?
3 0 3 0 6 6 7 8 1 4
浣跨敤鍙︿竴涓瀛愪負10鐨凴andom瀵硅薄鐢熸垚[0,10)鍐呴殢鏈烘暣鏁板簭鍒?
3 0 3 0 6 6 7 8 1 4
渚嬩笁:甯﹂殢鏈虹瀛愮殑闅忔満鏁?br />
import java.util.*;
public class test {
public static void main(String[] args) {
Random rand = new Random();
for(int i = 0; i < 10; i++) {
rand.setSeed(i);
System.out.println(rand.nextInt());
}
}
}
USE tempdb
GO
-- 鍒涘緩嫻嬭瘯琛?/span>
CREATE TABLE tb(id char(8))
-- 鍒涘緩鐢ㄤ簬鑷姩榪囨護閲嶅鍊肩殑鍞竴绱㈠紩
CREATE UNIQUE INDEX IX_tb ON tb(id)
WITH IGNORE_DUP_KEY
GO
-- 嫻嬭瘯鏁版嵁鎻掑叆鐨勫鐞嗘椂闂?/span>, 璁板綍寮濮嬪鐞嗙殑鏃墮棿鐐?/span>
DECLARE @dt datetime
SET @dt = GETDATE()
-- 鎻掑叆闅忔満鏁版嵁
SET NOCOUNT ON
DECLARE @row int
SET @row = 1000000 -- 璁劇疆鎬昏褰曟暟
WHILE @row >0
BEGIN
-- 鏄劇ず鎻愮ず淇℃伅, 琛ㄧず榪橀渶瑕佹彃鍏ュ琛屾暟鎹?/span>
RAISERROR('need %d rows', 10, 1, @row) WITH NOWAIT
-- 鎻掑叆闅忔満鐨勪綅緙栫爜鏁版嵁
SET ROWCOUNT @row
INSERT tb SELECT
id = RIGHT(100000000 + CONVERT(bigint, ABS(CHECKSUM(NEWID()))), 8)
FROM syscolumns c1, syscolumns c2
SET @row = @row - @@ROWCOUNT
END
-- 鏄劇ず鎻掑叆鏁版嵁浣跨敤鐨勬椂闂?/span>
SELECT BeginDate = @dt, EndDate = GETDATE(),
Second = DATEDIFF(Second, @dt, GETDATE()),
GO
-- 鏄劇ず鏈緇堢殑緇撴灉璁板綍鏄惁姝g‘
SELECT COUNT(*) FROM tb
GO
-- 鍒犻櫎嫻嬭瘯
DROP TABLE tb
瑙e喅涓敤鍒扮殑鎶宸э細
1錛?/font> 鎺у埗浜х敓鐨勬暟鎹笉閲嶅錛岀洿鎺ヤ嬌鐢ㄥ敮涓绱㈠紩涓殑IGNORE_DUP_KEY閫夐」錛屼嬌鎻掑叆鏁版嵁涓殑閲嶅鍊艱嚜鍔ㄨ繃婊わ紝閬垮厤鎵嬪伐澶勭悊閲嶅
2錛?/font> 浣跨敤CHECKSUM閰嶅悎NEWID()鍑芥暟錛屼嬌鐢熸垚鐨勬暟鎹敖閲忛殢鏈猴紝涓鑸敓鎴愰殢鏈烘暟浼氳冭檻浣跨敤RAND()鍑芥暟錛屼絾榪欎釜鍑芥暟鏄駭鐢熶吉闅忔満鍊鹼紝鐢ㄤ笅闈㈢殑璇彞嫻嬭瘯涓涓嬶紝浼氬彂鐜頒駭鐢熺殑鏁版嵁鍏ㄩ儴鏄竴鏍風殑錛岃繖涓嶉傜敤浜庢兂鎵歸噺鐢熸垚澶氫釜闅忔満鏁幫紝鑰?/span>NEWID()鍑芥暟鐢熸垚鐨勬槸GUID錛屽熀鏈笂涓嶄細鏈夐噸澶嶇殑錛屽啀閫氳繃CHECKSUM灝嗗叾杞寲鎴愭暟瀛楋紝榪欐牱浜х敓閲嶅鐨勫彲鑳芥т細姣旇緝灝?/span>
SELECT TOP 10
RAND()
FROM sysobjects
3錛?/font> 鍦ㄦ晥鐜囨帶鍒訛紝浣跨敤寰幆+鎵歸噺鐢熸垚鐨勬柟寮忥紝鑰屼笉鏄紶緇熺殑閫愪釜鐢熸垚銆傚湪SQL Server涓紝姣忎釜鎻掑叆璇彞閮戒細鏈変竴涓唴閮ㄧ殑浜嬪姟澶勭悊錛屽鏋滈愭潯鎻掑叆錛屽垯浜嬪姟鐨勫紑閿澶ぇ錛屾晥鐜囧娍蹇呴潪甯鎬綆錛涗笉鑰冭檻涓嬈℃х敓鎴?/span>100涓囨暟鎹紝涓鍒欏洜涓虹敓鎴愮殑鏁版嵁鍙兘鏈夐噸澶嶇殑錛屽幓鎺夐噸澶嶅氨娌℃湁100涓囦簡錛屼簩鍒欎竴嬈℃х敓鎴?/span>100涓囨暟鎹紝娑堣楃殑鍐呭瓨鍜?/span>CPU璧勬簮涔熷緢楂橈紝涓鑸殑鐢佃剳鍙兘鎵垮彈涓嶄綇