# Dashboard Slow on Pi Running Node-Red, But Fine on Other Devices
**URL:** https://discourse.nodered.org/t/dashboard-slow-on-pi-running-node-red-but-fine-on-other-devices/79382
**Category:** Dashboard
**Created:** [23 June 2023 20:25 UTC](https://discourse.nodered.org/t/dashboard-slow-on-pi-running-node-red-but-fine-on-other-devices/79382 "2023-06-23T20:25:39Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@ChZeman](https://discourse.nodered.org/u/ChZeman)
#### Post date: [23 June 2023 20:25 UTC](https://discourse.nodered.org/t/dashboard-slow-on-pi-running-node-red-but-fine-on-other-devices/79382/1 "2023-06-23T20:25:39Z")
I have a very basic dashboard that shows two tables (refreshed once per second, populated from a MySQL query) and some other information that is refreshed every 5 minutes. The Pi running NR, Pi 4 with 8GB RAM and a 128GB SD card, also runs a web browser to display the dashboard. It's been running fine for about 2 years but now I'm having a problem.
The dashboard will say "Connection Lost" and then refresh the page. This is happening quite frequently. If it's not doing that, the page is very slow to update. Everything runs perfectly on other devices viewing the dashboard through their own web browsers. I've rebooted the Pi, restarted the web browser, and tried other web browsers besides Chromium. Top shows chromium being its usual resource hog, but nothing out of the ordinary or too much consider what the Pi 4 has.
I'm not sure what else to check. I'm about ready to deploy a separate Pi for displaying the dashboard on our monitors.
```auto
top - 15:22:56 up 1 day, 23:57, 3 users, load average: 2.24, 2.00, 2.02
Tasks: 293 total, 2 running, 291 sleeping, 0 stopped, 0 zombie
%Cpu(s): 43.3 us, 6.1 sy, 0.0 ni, 49.2 id, 0.3 wa, 0.0 hi, 1.2 si, 0.0 st
MiB Mem : 7812.3 total, 4945.6 free, 1097.9 used, 1768.8 buff/cache
MiB Swap: 100.0 total, 100.0 free, 0.0 used. 6454.8 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
19667 user 20 0 845024 399280 104200 R 104.3 5.0 22:44.73 chromium-browse
3016 user 20 0 467752 357228 37280 S 60.5 4.5 1901:13 node-red
777 mysql 20 0 641292 99264 18476 S 9.9 1.2 262:03.14 mariadbd
19645 user 20 0 523580 106800 83784 S 6.9 1.3 1:54.73 chromium-browse
19592 user 20 0 592424 181548 145188 S 5.9 2.3 1:42.70 chromium-browse
19646 user 20 0 329528 75916 68404 S 4.6 0.9 1:13.44 chromium-browse
```
---
### Author:  [@E1cid](https://discourse.nodered.org/u/E1cid)
#### Post date: [23 June 2023 21:00 UTC](https://discourse.nodered.org/t/dashboard-slow-on-pi-running-node-red-but-fine-on-other-devices/79382/2 "2023-06-23T21:00:56Z")
One thread down had the same issue
> [@Node-Red editor running very quick on Windows - Very slow on Raspberry Pi - Why?](https://discourse.nodered.org/t/node-red-editor-running-very-quick-on-windows-very-slow-on-raspberry-pi-why/79365):
>
> The exact same json file runs very quick on my Windows PC, but very slow on the Raspberry Pi. The flow is quite large spread over many tabs, and I am using Dashboard as well. When I say quick, I mean when I am in the editor I click on a tab it will instantly change on Windows, but might take 5-10 seconds to open on the PI. Copy and paste of nodes very slow, opening a node to edit is slow, everything is slooooow. Its a 4Gb CM4. Running "free -m" shows I have 3838 total Mem, 762 used, 2477 free,…
Why a separate pi, why not a laptop, pc,mac or even a tablet and many more devices.
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [23 June 2023 21:02 UTC](https://discourse.nodered.org/t/dashboard-slow-on-pi-running-node-red-but-fine-on-other-devices/79382/3 "2023-06-23T21:02:11Z")
> [@ChZeman](#):
>
> I have a very basic dashboard that shows two tables (refreshed once per second, populated from a MySQL query
How many rows are you pushing to the dashboard?
Do you have charts? And if so, what is the the data size / history size of data/charts?
---
### Author:  [@ChZeman](https://discourse.nodered.org/u/ChZeman)
#### Post date: [25 June 2023 18:47 UTC](https://discourse.nodered.org/t/dashboard-slow-on-pi-running-node-red-but-fine-on-other-devices/79382/4 "2023-06-25T18:47:21Z")
A desktop Windows PC will probably be what I end up doing. I have a bag of Pis, too, which is why I was going to go that direction. The Pi feeds an HDMI distribution unit that feeds a number of TVs throughout our building. It's gives us the current status of most of our rides and alerts us instantly when a ride goes down, so the fact that it was lagging up to a minute at times was concerning. LOL
---
### Author:  [@ChZeman](https://discourse.nodered.org/u/ChZeman)
#### Post date: [25 June 2023 18:52 UTC](https://discourse.nodered.org/t/dashboard-slow-on-pi-running-node-red-but-fine-on-other-devices/79382/5 "2023-06-25T18:52:09Z")
No charts. It's just two tables. One has 20 rows and the other has... Well now! It just hit me that I had a scroll bar on the second table. I forgot to limit the number of results to 4 so it was processing everything in our occurrence list. I added LIMIT to my query and it seems to be running much better now. Thanks! 🤣
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [9 July 2023 18:52 UTC](https://discourse.nodered.org/t/dashboard-slow-on-pi-running-node-red-but-fine-on-other-devices/79382/6 "2023-07-09T18:52:30Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.