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?
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?