Hi! I made a complex game with node red that uses 130 mysql nodes The sql nodes a triggered between 1 sec and 30 seconds repeating In the beginning it worked very fast but now more and more the replies become slowly sometimes it takes 4 seconds to get a results The tables size doesnt matter, wi…

[image] RogierQ: uses 130 mysql nodes W.O.W why? At a wild guess (and depending on quite a few factors) but these 130 nodes will be the reason (potentially connections are being swamped). Or perhaps you are hitting wait locks on the database? Why dont you have just 1 sql node (or a smalle…

a lot of different checks and actions have been thinking to make it less but dont know how it is a lot of if/then and after succesfull insert or action back to database to set it as done for example

Changed now to 67 nodes. Used link nodes to one node for all single lines also had some sql node just for testing removed should that be a better approach? one sql node and multiple links to that node? But still a delay of 4-5 seconds before getting a result

What device are you running NR on? How much memory does it have? What else is running on the device? What type and how large is the storage is it using?

It runs on a vps server with lots of memory and cpu Running on ssd and nothing else running on it

Running the query in phpmyadmin goes in 0.0023 seconds :cry:

If you create a new flow (start nr with node-red dbspeed.flow or if running 'Projects' just start a new project) and just add an inject``, the sqlnode anddebug` how long does it take compared to phpMyAdmin? I'm trying to see if it is NR, the quantity of sql nodes or the rest of the flow...

That is still too many unless you are sure that they are using a shared connection. Otherwise you are not comparing like-for-like with your admin query. You should also replace all of your queries with pre-defined queries - "prepared statements" - as these will be vastly faster to execute.

[image] zenofmud: node-red dbspeed.flow tried it. then it runs very fast, almost instant

Ok, if it works fine in the little test, then there is something about the nubmber of sql nodes you are using or what ever else is happening in your flow.

Node-RED

Node-RED Forum

Slow database output +4 seconds

General

system Closed 1 January 2021 14:21 17

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Xampp node-red-node-mysql increased resources use General node-red-dashboard , database	13	639	28 May 2022
Node-RED freezes while sqlite query General sqlite	24	578	2 March 2024
Node-red-node-mysql: mysql query blocks node-red General	2	712	10 April 2021
Maximum Insert Speed for mySQL through network? General	33	1985	4 September 2019
ETIMEOUT error - MSSQL PLUS General	34	4523	17 April 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Slow database output +4 seconds

Related topics