Forum

Slow SQL database conection

Hey everybody

We are wondering about the “database” node. We can conect to our database and send query through the “select” node. The thing is it takes around 6 seconds to recive the data. Looks like at every query we send we conect and disconect to the database. Can that be right?

Any idea to send several querys and have a fast reply from the database?

Thank you very much!

The thing is it takes around 6 seconds to receive the data.
Looks like at every query we send we connect and disconnect to the database. Can that be right?

Normally the database-node stays connected until the connection is interrupted (due to bad lan/wan/internet-connection) or times out (the database does not respond / the response-time is too long). So I think it takes your database too long to respond or the connection is too slow.

Where is your database: on the same computer, in another room (lan) or far away (wan/internet)?

How complex is the query?

Have you queried the database using other tools/webapplications?
If yes are the response-times shorter?

Which MySQL-Version do you use?

Thanks for the reply, actually we switched to the HTTP node and conecting through the web… Maybe we did something wrong.
But now its somehow working.

Thank you again

could have been related to that problem