°ÙÍòÊý¾ÝÏÂmysql·ÖÒ³ÌâÄ¿
select * from news order by id desc limit 0,10 ºÄʱ0.003Ãë select * from news order by id desc limit 10000,10 ºÄʱ0.058Ãë select * from news order by id desc limit 100000,10 ºÄʱ0.575Ãë select * from news order by id desc limit 1000000,10 ºÄʱ7.28Ãë
ÎÒÃǾªÌ¾µÄ·¢Ã÷mysqlÔÚÊý¾ÝÁ¿´óµÄ×´¿öÏ·ÖÒ³ÆðµãÔ½´ó²éѯËÙ¶ÈÔ½Âý£¬100ÍòÌõÆðµÄ²éѯËÙ¶ÈÒѾÐèÒª7ÃëÖÓ¡£ÕâÊÇÒ»¸öÎÒÃÇû·¨³ÐÊܵÄÊýÖµ£¡
¸ÄÉÆ·½°¸ 1
select * from news where id > (select id from news order by id desc limit 1000000, 1) order by id desc limit 0,10
²éѯ¹¤·ò 0.365Ã룬Ìá°ÎЧÂÊÊǷdz£ÏÔÃ÷µÄ£¡£¡µÀÀíÓÐÄÄЩÄØ£¿£¿£¿
ÎÒÃÇÔËÓÃÇ°Ìá¶Ôid½øÐÐÁËɸѡ£¬ÔÚ×Ó²éѯ (select id from news order by id desc limit 1000000, 1) ÖÐÎÒÃÇÖ»²éѯÁËidÕâÒ»¸ö×ֶαÈÆðselect * »ò select ¶à¸ö×ֶΠ½Ú¼óÁËÅúÁ¿µÄ²éѯ¿ªÏú£¡
¸ÄÉÆ·½°¸2
ÊʺÏid½ÐøµÄϵͳ£¬Ëٶȼ«¿ì£¡
select * from news where id between 1000000 and 1000010 order by id desc
²»ÊʺϴøÓÐÇ°ÌáµÄ¡¢id²»Â½ÐøµÄ²éѯ¡£Ëٶȷdz£¿ì£¡
ÒÔÉϾÍÊÇ°ÙÍòÊý¾ÝÏÂmysql·ÖÒ³ÌâÄ¿µÄϸÖÂÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢ °Ù·Ö°ÙÔ´ÂëÍø ÆäËüÏà¸ÉÎÄÕ£¡
¸ÐлÄúµÄÖ§³Ö£¬ÎÒ»á¼ÌÐøŬÁ¦µÄ!
´ò¿ªÖ§¸¶±¦É¨Ò»É¨£¬¼´¿É½øÐÐɨÂë´òÉÍŶ
°Ù·Ö°ÙÔ´ÂëÍø ½¨Òé´òÉÍ1¡«10Ôª£¬ÍÁºÀËæÒ⣬¸ÐлÄúµÄÔĶÁ£¡