--<\/p>\n
\u76f8\u8f03\u65bc PHP\uff0cPython \u56e0\u70ba\u53ef\u4ee5\u81ea\u7531\u9078\u64c7\u6a21\u7d44\uff0c\u6240\u4ee5\u5c31\u7b97\u662f\u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e5f\u6709\u5f88\u591a\u7a2e\u65b9\u5f0f\uff0c\u5728\u6b64\u4f7f\u7528 MySQLdb, pymysql, mysql.connector \u4e09\u7a2e\u6a21\u7d44\u4f86\u6bd4\u8f03\u7a0b\u5f0f\u4ee5\u53ca\u6548\u80fd\u7684\u5dee\u7570\u3002<\/p>\n
--<\/p>\n
--<\/p>\n
\u5b89\u88dd<\/p>\n
pip3 install mysqlclient<\/pre>\nPython \u7a0b\u5f0f\u78bc<\/p>\n
import MySQLdb\r\nimport time\r\n\r\ndb = MySQLdb.connect(host=\"192.168.6.121\", user=\"user\", password=\"password\", database=\"database\", autocommit=True)\r\ncursor = db.cursor(MySQLdb.cursors.DictCursor)\r\n\r\nstart_time = time.time()\r\n\r\nfor i in range(0, 10000):\r\n sql = \" INSERT INTO Room (Game) VALUES ('') \"\r\n cursor.execute(sql)\r\n\r\n sql = \" UPDATE Room SET Game=Game+1 WHERE id=%(id)s \"\r\n cursor.execute(sql, {\r\n 'id': i\r\n })\r\nprint(time.time() - start_time) # 28.631089210510254\r\n\r\nsql = \" SELECT * FROM Room WHERE id=%(id)s \"\r\ncursor.execute(sql, {\r\n 'id': 1\r\n})\r\nprint(cursor.rowcount)\r\na = cursor.fetchone()\r\nprint(a)<\/pre>\n--<\/p>\n
PyMySQL<\/h2>\n
\u5b89\u88dd<\/p>\n
pip3 install PyMySQL<\/pre>\nPython \u7a0b\u5f0f\u78bc<\/p>\n
import pymysql\r\nimport time\r\n\r\ndb = pymysql.connect(host=\"192.168.6.121\", user=\"user\", password=\"password\", database=\"database\", autocommit=True)\r\ncursor = db.cursor(pymysql.cursors.DictCursor)\r\n\r\nstart_time = time.time()\r\n\r\nfor i in range(0, 10000):\r\n sql = \" INSERT INTO Room (Game) VALUES ('') \"\r\n cursor.execute(sql)\r\n\r\n sql = \" UPDATE Room SET Game=Game+1 WHERE id=%(id)s \"\r\n cursor.execute(sql, {\r\n 'id': i\r\n })\r\nprint(time.time() - start_time) # 31.950004816055298\r\n\r\nsql = \" SELECT * FROM Room WHERE id=%(id)s \"\r\ncursor.execute(sql, {\r\n 'id': 1\r\n})\r\nprint(cursor.rowcount)\r\na = cursor.fetchone()\r\nprint(a)<\/pre>\n--<\/p>\n
MySQL Connectors<\/h2>\n
\u5b89\u88dd<\/p>\n
pip3 install mysql-connector<\/pre>\nPython \u7a0b\u5f0f\u78bc<\/p>\n
import mysql.connector\r\nimport time\r\n\r\ncnx = mysql.connector.connect(user='user', password='password', host='192.168.6.121', port=3306, database='database', autocommit=True)\r\ncursor = cnx.cursor(dictionary=True, buffered=True)\r\n\r\nstart_time = time.time()\r\n\r\nfor i in range(0, 10000):\r\n sql = \" INSERT INTO Room (Game) VALUES ('\" + str(i) + \"') \"\r\n cursor.execute(sql)\r\n\r\n sql = \" UPDATE Room SET Game=Game+1 WHERE id=%(id)s \"\r\n cursor.execute(sql, {\r\n 'id': i\r\n })\r\nprint(time.time() - start_time) # 28.920193672180176\r\n\r\nsql = \" SELECT * FROM Room WHERE id=%(id)s \"\r\ncursor.execute(sql, {\r\n 'id': 1\r\n})\r\nprint(cursor.rowcount)\r\na = cursor.fetchone()\r\nprint(a)<\/pre>\n--<\/p>\n
\u7d50\u8ad6<\/h2>\n
\u53ef\u80fd\u591a\u5e74\u524d\u4e0d\u540c\u6a21\u7d44\u6709\u6548\u80fd\u6216\u529f\u80fd\u4e0a\u7684\u5dee\u7570\uff0c\u53ef\u662f\u73fe\u5728 2024 \u5e74\u5dee\u7570\u5df2\u7d93\u5f88\u5c0f\uff0c\u6240\u4ee5\u5728\u9078\u64c7\u4e0a\u53ef\u4ee5\u6839\u64da\u7576\u6642\u6a21\u7d44\u7dad\u8b77\u7684\u72c0\u6cc1\u5373\u53ef<\/p>\n
--<\/p>\n
<\/div>\n