mysqlËæ»úÊý¾ÝÉú³É²¢²åÈë
dblpÊý¾Ý¿âÖÐÒýÓÃÐÅÏ¢ºÜÉÙ£¬Æ½¾ùһƪÂÛÎÄÒýÓÃ0.2ƪ¡£Ê¹ÓÃdblp×öʵÑéÊý¾Ý¼¯µÄijƪÂÛÎÄÌáµ½£¬¿ÉÒÔËæ»úÌí¼ÓÒýÓÃÐÅÏ¢¡£ÊÜ´ËÆô·¢£¬ÎÒ´òËãΪÿһƪÂÛÎͼÌí¼Ó20ÆªËæ»úÒýÓã¬ÓÚÊǾÍд³öÁËÈçϵÄsqlÓï¾ä£º
String sql = "insert into citation(pId1,pId2) values( (select pId from papers limit ?,1),(select pId from papers
limit ?,1))";
ʹÓÃpreparedstatement£¬ÒÔbatch·½Ê½Ìá½»Êý¾Ý¿â¡£
µÚÒ»¸ö²ÎÊýÊÇpaperµÄrowidÐÅÏ¢£¬´Ó0~N£¨NΪpapersµÄtotal row£©¡£µÚ¶þ¸ö²ÎÊýÊÇjavaÉú³ÉµÄ20¸ö²»Öظ´µÄËæ»úÊý£¬·¶Î§ÊÇ0-N¡£È»ºóǶÌ×ÔÚforÑ»·Àÿ1wÌõÊý¾ÝÌá½»¸øÊý¾Ý¿âÒ»´Î¡£
Õâ¶Î´úÂëÇÉÃîÔËÓÃlimitµÄÌØÐÔÍê³ÉËæ»úÑ¡tuple£¬±¾À´Êǰµ°µµÃÒâµÄ¡£×ÔÒÔΪ°ÑËùÓеÄselect¶¼½»¸øÊý¾Ý¿âÈ¥×öÁË£¬Ê¡È¥ÁËͨ¹ýjdbcµÄ¶à´ÎÁ¬½Ó£¬Ó¦¸ÃÊǺܿì¾Í¿ÉÒÔÔËÐÐÍê³ÉµÄ¡£ÄÄÖª£¬²åÁ˲»¹ý10wÌõ£¨10000*10£©Êý¾Ý£¬¾ÍºÄʱ22·ÖÖÓÖ®¶à¡£×îÖÕµÄʵÑéÐèÒª²åÈë400wÌõÊý¾Ý£¬Ò²¾ÍÊÇ˵Ҫ»¨14h×óÓÒ¡£
ÓÚÊÇ¿ªÊ¼·´Ë¼£¬²»¶Ï×öдÀàËÆµÄ³ÌÐò²éÕÒʱ¼äÆ¿¾±£¬×îÖÕËø¶¨ÔÚselect limit£¬Õâ¸ö²Ù×÷¼«ºÄʱ¼ä¡£µ±³õÑ¡ÓÃlimit£¬ÔÒòÔÚÓÚ£ºËæ»úÉú³ÉµÄÊÇÊý×Ö£¬Òª°ÑÊý×ÖÓ³Éäµ½tuple£¬Ò²¾ÍÊǶÔÓ¦µ½rowid£»ÓÉÓÚpapers±íµÄÖ÷¼ü²¢·ÇµÝÔöint£¬ËùÒÔĬÈϵÄrowid²»´æÔÚ¡£ºóÀ´Ò»Ï룬¿ÉÒÔÔÚpapers±íÉÏÏÈÔö¼ÓÒ»¸öauto_incrementµÄtempÁУ¬Íê³Écitation²åÈëºóÔÙɾ³ý¡£ÕâÑùsqlÓï¾ä¾Í¸Ä³ÉÁË£º
String sql = "insert into citation(pId1,pId2) values((select pId from papers where temp=?), (select pId from
papers where temp=?))";
ÔÙÒ»´Î²åÈë10wÌõÊý¾Ý£¬ºÄʱ38s¡£Ð§ÂÊ´ó·ùÌá¸ß£¬µ«²»ÖªµÀ»¹¿É²»¿ÉÒÔ½øÒ»²½ÓÅ»¯¡£
Ïà¹ØÎĵµ£º
· ÄÚ²¿¹¹¼þºÍ¿ÉÒÆÖ²ÐÔ
o ÌṩÁËÊÂÎñÐԺͷÇÊÂÎñÐÔ´æ´¢ÒýÇæ¡£
--ÊÇ·ñÖ¸Èç¹ûÒª²ÉÓÃÊÂÎñ¹ÜÀí£¬±ØÐëÇл»´æ´¢ÒýÇæ£¿£¿£¿
· Óï¾äºÍº¯Êý
DELETE¡¢INSERT¡¢REPLACEºÍUPDATE·µ»Ø¸ü¸Ä£¨Ó°Ï죩µÄÐÐÊý¡£Á¬½Óµ½·þÎñÆ÷ʱ£¬¿Éͨ¹ýÉèÖ ......
mysql version 5.1
ÔÚmysql´´½¨±íµÄʱºò¾³£»áÓöµ½´´½¨ÈÕÆÚ×Ö¶ÎÐèÒªÉèÖõ±Ç°Ê±¼äΪĬÈÏÖµµÄʱºò£¬¾ÍÈçsqlserver2000Ò»Ñù£¬°ÑĬÈÏÖµÉèΪgetdate()¼´¿É£¬ÎÒÔÚÍøÉϲéÁËN¾Ã¶¼Ã»Óв鵽ʹÓÃÓÐЧµÄ·½·¨£¬×îºó×Ô¼ºÑо¿ÁËһЩ·½·¨Óë´ó¼Ò·ÖÏí£º
Êý¾Ý¿â£ºtest_db1
´´½¨±í£ºtest_ta1
Á½¸ö×Ö¶ ......
[ ÅäÖÃ ]
Ö´ÐÐÔöÁ¿±¸·ÝµÄǰÌáÌõ¼þÊÇMySQL´ò¿ªlog-binÈÕÖ¾¿ª¹Ø£¬ÀýÈçÔÚmy.ini»òmy.cnfÖмÓÈë log-bin=C:/Program Files/MySQL/MySQL Server 6.0/Data/mysql-bin “log-bin=”ºóµÄ×Ö·û´®ÎªÈÕÖ¾¼ÇÔØÄ¿Â¼£¬Ò»°ã½¨Òé·ÅÔÚ²»Í¬ÓÚmysqlÊý¾ÝĿ¼µÄ´ÅÅÌÉÏ¡£
[ ÍêÈ«±¸·Ý]
¼Ù¶¨ÐÇÆÚÈÕÏÂÎç1µãÖ´ÐÐÍêÈ«±¸·Ý£¬ÊÊÓÃÓÚMyISAM ......
½ñÌì°²×°mysqlÓöµ½ºÜ¶àÂé·³£¬ÏëÏóÔÒò£¬×Ô¼º»¹ÊÇlinuxµÄ³õѧÕߣ¬Í¬Ê±ÊÜ´ìʱ×ÜÊÇÒª°ÑÎÊÌâµÄ¸´ÔÓϵÊý·Å´ó¡£
1 °²×°³åÍ»
¸ù¾Ý¡¶linux³ÌÐòÉè¼Æ¡·ÉϵÄÖ¸µ¼£¬´Ó¹ÙÍøÏÂÔØÁËmysql-server-xx£¬mysql-devel-xx£¬mysql-client-xx£¬mysql-share-xx£¬È»ºóÖ´ÐÐ
rpm -i *.rpm
½á¹û¶þÊ®¼¸ÐÐconflictÌáʾ£¬ËµÓÐÎļþÓëmysql-server-xxµÄ°² ......