Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚmysqlµÄinsertÐÔÄÜ

²É¼¯ÏµÍ³£¬Ïë°ÑÓб仯µÄÊý¾Ý²åÈëÊý¾Ý¿â¡£

´ó¸Å1ÃëÖÓÓб仯µÄÁ¿2000¸ö×óÓÒ¡£ÊýÖµÊÇfloatÐÍ£¬Ò²¾ÍÊÇ8000¸ö×Ö½Ú¡£

ÏÖÔÚÓÐÁ½ÖÖ·½·¨£º
1 ÅúÁ¿ insert£¬Ã¿¸ö±ä»¯±£´æ1Ìõ¼Ç¼£¨²éѯ·½±ã£©£¬insert into values£¨£©£¨£©Ò»¹²2000¸ö£¬ ºÄʱ120ms¡£
2 °ÑÒ»¸ö¶þ½øÖÆÊý×éÖ±½Ó±£´æµ½longblob ×ֶΣ¬·¢ÏÖ380000¸ö×Ö½Ú£¬Ò²Ö»Òª10ms¡£

²î¾àÕæµÄÕâô´ó£¿£¿£¿£¿

µÚ2ÖÖ·½·¨ÓÖ¿ÉÒÔÓÐ2ÖÖ
1 Ö»±£´æ±ä»¯£¬¶þ½øÖƸñʽ¡¾±ä»¯Á¿ID,±ä»¯Á¿Öµ¡¿£¬£¬£¨ÕâÑù±£´æµÄÊý¾ÝÁ¿Ð¡ £¬µ«ÊDzéѯºÜÀ§ÄÑ£¬Òª½âÎö¶þ½øÖÆ £©
2 Ö»Òª¸ÃÃëÓб仯£¬¾Í¼Ç¼ËùÓеÄÁ¿£¬£¨ÕâÑù²éѯ±È½Ï¼òµ¥£¬Ö±½ÓËãÐèÒªµÄÁ¿µÄÆ«ÒÆÁ¿¾Í¿ÉÒÔ£©

Âé·³ÄÄλ¸ßÊÖ°ï·ÖÎöһϡ£
ÓÐЩÏó¹¤ÒµÏµÍ³µÄÉè¼Æ¡£

Ò»°ãÊÇÉÏλ»ú»á°´µÚ¶þÖÖ·½·¨ÖеĵڶþÖÖ¸ñʽ½øÐС£Óб仯ʱ¼Ç¼ËùÓеÄÁ¿£¬Ö±½Ó°ÑÏÂÃæµÄÐÅÏ¢£¨±¾ÉíÒѾ­ÔÚÄÚ´æµÄ¿éÖУ©È«²¿Ð´Èëµ½´ÅÅÌ»òÊý¾Ý¿â¡£

¶øºǫ́Ö÷»úÔò¸ºÔðÂýÂýµÄ´¦Àí£¬ÒÔ¹©±¨±í·ÖÎöʹÓá£

ÒýÓÃ
ÓÐЩÏó¹¤ÒµÏµÍ³µÄÉè¼Æ¡£

Ò»°ãÊÇÉÏλ»ú»á°´µÚ¶þÖÖ·½·¨ÖеĵڶþÖÖ¸ñʽ½øÐС£Óб仯ʱ¼Ç¼ËùÓеÄÁ¿£¬Ö±½Ó°ÑÏÂÃæµÄÐÅÏ¢£¨±¾ÉíÒѾ­ÔÚÄÚ´æµÄ¿éÖУ©È«²¿Ð´Èëµ½´ÅÅÌ»òÊý¾Ý¿â¡£

¶øºǫ́Ö÷»úÔò¸ºÔðÂýÂýµÄ´¦Àí£¬ÒÔ¹©±¨±í·ÖÎöʹÓá£


лл£¬¾ÍÊǹ¤ÒµÏµÍ³ÖÐÉÏλ»úµÄ´æ´¢£¬ÕýÏë°´µÚ¶þÖÖ·½Ê½×ö£¬Ì«¸ÐлÁË¡£

ûÓÐÆäËûר¼ÒÌṩһµã²Î¿¼Òâ¼ûÂ𣿣¿£º£©

Äã¿ÉÒÔ½«ÄãÁ½ÖÖ·½°¸µÄÖ´ÐÐʱ¼ä±È½ÏÒ»ÏÂ

µÚÒ»ÖÖ¼ÓÉϽâÎö¶þ½øÖƵÄʱ¼ä¿´¿´ÄǸöÖ´ÐÐЧÂʸß


ÒýÓÃ
Äã¿ÉÒÔ½«ÄãÁ½ÖÖ·


Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

mysql µ¼ÖÂËÀ»ú

»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ