Welcome, Guest
Username: Password: Remember me

TOPIC: Database and chart problem

Database and chart problem 3 years 10 months ago #1060

  • Richter
  • Richter's Avatar
  • Offline
  • Junior Member
  • Posts: 25
  • Karma: 0
Hi,
I made a database and charts.
Excessive memory and CPU usage when displaying graphs. SW freezes.
The database has only about 400kb so far (1 day logs)
Please, give me an advice.
Thank you
The administrator has disabled public write access.

Database and chart problem 3 years 10 months ago #1061

  • Richter
  • Richter's Avatar
  • Offline
  • Junior Member
  • Posts: 25
  • Karma: 0
The administrator has disabled public write access.

Database and chart problem 3 years 10 months ago #1062

  • fatkhrus
  • fatkhrus's Avatar
  • Offline
  • Administrator
  • Posts: 826
  • Thank you received: 123
  • Karma: -107
Hello,

What's the version of TeslaSCADA2 Runtime do you use? Can you send us your project and database?

Best regards,
Ruslan
The administrator has disabled public write access.

Database and chart problem 3 years 10 months ago #1063

  • fatkhrus
  • fatkhrus's Avatar
  • Offline
  • Administrator
  • Posts: 826
  • Thank you received: 123
  • Karma: -107
Hello,

We’ve studied your project. The problem is that your history database FVE save period is too small - 1000 ms. It collects too many data in database. For 8 tags - 8 values in second, 480 values in minute, almost 30000 values in hour and almost 700000 in day. When you try to handle it by using charts it takes too much time (on my PC almost 30 seconds). At this period because your period is 1000ms history database put another scope of values into database, and because all your trends are auto refreshed they tried to update graphics and try to handle 700000 values again.

I recommend you to increase history database FVE save period at least to 10000ms. And uncheck “Auto refresh” for all trends (charts).

I think in the next version we’ll solve this problem for charts by handling such big data automatically, but at this moment use my recommendations.

Best regards,
Ruslan
Last Edit: 3 years 10 months ago by fatkhrus.
The administrator has disabled public write access.
Go to top