MemcacheºÍMsSQL½»»¥Á÷³Ìͼ
MemcacheºÍMsSQL½»»¥Á÷³Ìͼ
ÈçÉÏͼ£¬´«Í³µÄ²éѯ·½·¨ÊÇÖ±½Ó²éѯÊý¾Ý¿â£¬Êý¾Ý¿â½«½á¹û·µ»Ø¸ø²éѯÓï¾ä£¬¶øµ±ÓÐMemcacheÖм仺´æ²ãʱ£¬²éѯµÄÊÇMemcache»º´æÊý¾Ý£¬ÏÂÃæÏêϸÁ˽âMemcache¸÷ÀàÊý¾Ý²Ù×÷ÔÀí£º
1£¬²éѯÊý¾Ý(select)£¬Ê×ÏÈͨ¹ýÖ¸¶¨µÄKey²éѯ(get)MemcacheÖм仺´æ²ãÊý¾Ý£¬Èç¹û´æÔÚÏà¶ÔÓ¦Êý¾Ý£¬ÔòÖ±½Ó»ñÈ¡³öÊý¾Ý½á¹û£¬²éѯ¹ý³ÌÍêÈ«²»ÐèÒª²éѯÊý¾Ý¿â¡£Èç¹û²»´æÔÚ£¬Ôò²éѯMsSQLÊý¾Ý¿â£¬²¢ÒÔkey¶ÔÓ¦valueµÄÐÎʽ½«²éѯ½á¹û´æ´¢ÔÚMemcache»º´æÊý¾ÝÖУ¬È»ºó½«½á¹û·µ»Ø¸ø²éѯÓï¾ä¡£
2£¬¸üÐÂÊý¾Ý(update)£¬Ê×ÏȸüÐÂÊý¾Ý£¬È»ºóɾ³ýÏà¹ØµÄmemcacheÊý¾Ý(delete)¡£
3£¬Ôö¼ÓÊý¾Ý(add)£¬Ê×ÏÈɾ³ýÏà¹Ø»º´æÊý¾Ý£¬È»ºóÔö¼ÓÊý¾Ý¡£
4£¬É¾³ýÊý¾Ý(delete)£¬É¾³ýÊý¾Ý£¬²¢É¾³ýMemcacheÊý¾Ý¡£
¶ÔMsSQLµÄÊý¾Ý²Ù×÷£¬Ö÷ÒªÉæ¼°µ½µÄMemcache·½·¨ÈçÏ£º
1£¬»ñÈ¡£ºget(key)
2£¬ÉèÖãºset(key, value [, expiry])
3£¬É¾³ý£ºdelete(key [, time])
ʵÀý£º
¼ÙÉèÒ»¸öÌù×Ó£¬»ñÈ¡Ìù×ÓIDΪ2009µÄÖµ£¬ÆäMemcacheÓëMsSQL½»»¥Á÷³ÌÈçÏ£º
string key = "sky";//keyǰ׺
int cachetime = 100;//»º´æÓÐЧʱ¼ä(Ãë)
string id = "2009";
Memcache»ù±¾²Ù×÷¹ý³Ì
1£¬²éѯ£ºresult = get(key+id);Èç¹ûresultΪ¿Õ£¬Ôò²éѯMsSQLÊý¾Ý¿â£¬È»ºóset(key+id,value,0,cachetime)
2£¬¸üУºÖØÐÂset
3£¬Ôö¼Ó£ºsetеÄkey
4£¬É¾³ý£ºdelete(key+id);
Ïà¹ØÎĵµ£º
µ±Êý¾Ý·þÎñÆ÷ºÍWeb·þÎñÆ÷²¿ÊðÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏʱ£¬»áÓõ½·Ö²¼Ê½ÊÂÎñ£¬ÐèÒª¶ÔÁ½¸ö·þÎñÆ÷µÄMSDTC½øÐÐÅäÖá£
´ò¿ª“¹ÜÀí¹¤¾ß¨D¨D×é¼þ·þÎñ”£¬ÒÔ´Ë´ò¿ª“×é¼þ·þÎñ¨D¨D¼ÆËã»ú”£¬ÔÚ“ÎҵĵçÄÔ”Éϵã»÷ÓÒ¼ü¡£ÔÚMSDTCÑ¡ÏÖУ¬µã»÷“°²È«ÅäÖÔ°´Å¥¡£ ......
´Ómssql6.5¿ªÊ¼£¬Î¢ÈíÌṩÁËÁ½¸ö²»¹«¿ª£¬·Ç³£ÓÐÓõÄϵͳ´æ´¢¹ý³Ìsp_MSforeachtableºÍsp_MSforeachdb£¬ÓÃÓÚ±éÀúij¸öÊý¾Ý¿âµÄÿ¸ö±íºÍ±éÀúDBMS¹ÜÀíϵÄÿ¸öÊý¾Ý¿â¡£
ÎÒÃÇÔÚmasterÊý¾Ý¿âÀïÖ´ÐÐÏÂÃæµÄÓï¾ä¿ÉÒÔ¿´µ½Á½¸öprocÏêϸµÄ´úÂë
use master
exec sp_helptext sp_MSforeachtable
exec sp_helptext sp_Msforeachdb
sp_M ......
Ëø»úÖÆ
NOLOCKºÍREADPASTµÄÇø±ð¡£
1. ¿ªÆôÒ»¸öÊÂÎñÖ´ÐвåÈëÊý¾ÝµÄ²Ù×÷¡£
BEGIN TRAN t
INSERT INTO Customer
SELECT 'a','a'
2. Ö´ÐÐÒ»Ìõ²éѯÓï¾ä¡£
SELECT * from Customer WITH (NOLOCK)
½á¹ûÖÐÏÔʾ"a"ºÍ"a"¡£µ±1ÖÐÊÂÎñ»Ø¹öºó£¬ÄÇôa½«³ÉΪÔàÊý¾Ý¡£(×¢:1ÖеÄÊÂÎñδÌá½») ¡£NOLOCK±íÃ÷ûÓжÔÊý¾Ý±íÌí¼Ó¹²Ï ......
1.
--½«ºº×Öת»»ÎªÆ´ÒôÊ××Öĸ
CREATE function GetAllPY(@str nvarchar(4000))
returns nvarchar(4000)
--WITH ENCRYPTION
as
begin
declare @intLen int
declare @strRet nvarchar(4000)
declare @temp nvarchar(100)
set @intLen &nb ......
--´Ë´úÂëʵÏÖSQLÊý¾Ý¿âÔ¶³Ì±¸·Ý£¬·Åµ½×÷ÒµÀïÃæÖ´ÐпÉÒÔ×Ô¶¯±¸·ÝÊý¾Ý¿â¡¢×Ô¶¯É¾³ý@keepNDaysÌìÇ°±¸·Ý¡£
--´Ë´úÂ뽫±¾µØËùÓеÄÓû§Êý¾Ý¿â±¸·Ýµ½¹²ÏíĿ¼¡°\\backupServerIp\ShareName\Êý¾Ý¿â±¸·Ý¡±Ï¡£
--²¢É¾³ýÌìÇ°µÄ±¸·ÝÎļþ¡£Òª±¸·Ý³É¹¦±ØÐëÄܹ»¶Ô¹²ÏíĿ¼ÓвÙ×÷ȨÏÞ£¡
sp_configure 'xp_cmdshell',1 ......