How can I cache mysql connection in Flask

Asked Apr 28 '18 at 09:10

Active Apr 28 '18 at 09:10

Viewed 475 times

I am using Flask app. Here is an api that selects data from mysql and return data to client.

In every request, I connect mysql.

cnx = mysql.connector.connect(user='xx', password='xx',
                              host='xx',
                              database='xx')

In my opinion, the connection takes time. So how can I use this cache? Because it seems unnecessary to connect mysql database every time.

asked Apr 28 '18 at 09:10

CoXier

1

Search for "connection pool". – raspi Apr 28 '18 at 09:12
Please post your code. – Colin Ricardo Apr 28 '18 at 09:12
What code ?@Colin – CoXier Apr 28 '18 at 09:14
Possible duplicate of [How to create a mysql connection pool or any better way to initialize the multiple databases?](https://stackoverflow.com/questions/32658679/how-to-create-a-mysql-connection-pool-or-any-better-way-to-initialize-the-multip) – stamaimer Apr 28 '18 at 10:50

0 Answers0