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, with 100 or 30000 records
The querry is like below
SELECT * FROM `telegram` WHERE `messageType` = 'telegram' AND `send`= '0' AND `time` < '"+time+"' ORDER BY `time` LIMIT 1
Running latest versions of node red and sql node, database is mariadb
strange thing is that when i run a query in phpmyadmin it runs very fast and it seems that it affects the speed in node red, it seems to run faster then
allready added different indexes on fields without result
any help is welcome!