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);
Ïà¹ØÎĵµ£º
´Ómssql6.5¿ªÊ¼£¬Î¢ÈíÌṩÁËÁ½¸ö²»¹«¿ª£¬·Ç³£ÓÐÓõÄϵͳ´æ´¢¹ý³Ìsp_MSforeachtableºÍsp_MSforeachdb£¬ÓÃÓÚ±éÀúij¸öÊý¾Ý¿âµÄÿ¸ö±íºÍ±éÀúDBMS¹ÜÀíϵÄÿ¸öÊý¾Ý¿â¡£
ÎÒÃÇÔÚmasterÊý¾Ý¿âÀïÖ´ÐÐÏÂÃæµÄÓï¾ä¿ÉÒÔ¿´µ½Á½¸öprocÏêϸµÄ´úÂë
use master
exec sp_helptext sp_MSforeachtable
exec sp_helptext sp_Msforeachdb
sp_M ......
--×Ö¶ÎÌí¼Ó˵Ã÷
EXEC sp_addextendedproperty 'MS_Description', 'ÒªÌí¼ÓµÄ˵Ã÷', 'user', dbo, 'table', ±íÃû, 'column', ÁÐÃû
--ɾ³ý×Ö¶Î˵Ã÷
EXEC sp_dropextendedproperty 'MS_Description', 'user', dbo, 'table', ±íÃû, 'column', ×Ö¶ÎÃû
--²é¿´×Ö¶Î˵Ã÷
SELECT
[Table Name] = i_s.TAB ......
×î½üÓиöС¶«Î÷Òª²é¿´mssqlÊý¾Ý¿âÊÇÓÃphpʵÏֵģ¬ÒÔÇ°ÎÒÓÃphp5.2ʱ¸Ð¾õͦ¼òµ¥µÄËùÒÔÏëphp5.3Ò²Ó¦¸ÃºÜ¼òµ¥µÄ
ΪʲôҪÓÃphp5.3ÄØÒòΪÎÒÏëÓÃsqlite3.0µÄ°¡£¬ÒòΪphp5.2µÄ²»Ö§³Ösqlite3.0µÄ°¡£¬ËùÒÔÎÒÌØÒâÈ¥ÏÂÁË5.3ÁËÏÂÔØ»ØÀ´Á˲ŷ¢ÏÖ5.3ÀïûÓÐmssqlµÄdllÀ©Õ¹ÁË£¬ÓôÃÆ°¡£¬²»¹ÜÕâô¶àÏÈÓÃÆðÄÇsqlite3.0ÔÙ˵ÁË
sqlite3.0µÄ²¿·Ö ......
1.°´ÐÕÊϱʻÅÅÐò:
Select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
2.·ÖÒ³SQLÓï¾ä
select * from(select (row_number() OVER (ORDER BY tab.ID Desc)) as rownum,tab.* from ±íÃû As tab) As t where rownum between ÆðʼλÖà And ½áÊøλÖÃ
3.»ñÈ¡µ±Ç°Êý¾ ......