SQL Blockzeit Aufzeichnung für echarts
-
Bin gerade dabei das System etwas aufzuräumen und meine gesamten FLOAT Diagramme durch echarts zu ersetzen.
Gehe ich auf ein Objekt in den Verlaufsdaten dauert es zunächst ewig bis die Daten geladen sind. Diese Daten haben eine Zeit Differenz von ~1 Sekunde, die Einstellungen im SQL Adapter sind allerdings mit einer Blockzeit von 2 Sekunden eingestellt, exportiere ich die Daten dann passt das in etwa mit der eingestellten Blockzeit.Warum dauert es ewig bi Verlaufsdaten von 10 Minuten geladen sind, hier werden offensichtlich auch nicht die SQL Aufzeichnung dargestellt, Quelle ist hier immer der javascript Adapter?
Was sind die optimalen Einstellungen unter SQL für die spätere grafische Darstellung in echarts. Früher musste ich z.B. trotzdem gleiche Werte aufzeichnen benutzen, weil sonst unter Umständen in kürzen Diagrammen der Wert nicht angezeigt wurde weil kein Datenpunkt für den Zeitraum vorhanden war, ist das mit den echarts auch weiter notwendig?Konfiguration
Verlauf Daten
Excel Export code_text ```timestamp value acknowledged from 2022-10-15T20:30:00.581Z 895.71 false javascript.0 2022-10-15T20:30:03.512Z 889.21 false javascript.0 2022-10-15T20:30:05.544Z 650.21 false javascript.0 2022-10-15T20:30:08.530Z 654.41 false javascript.0 2022-10-15T20:30:10.653Z 663.91 false javascript.0 2022-10-15T20:30:13.563Z 651.71 false javascript.0 2022-10-15T20:30:15.576Z 656.21 false javascript.0 2022-10-15T20:30:18.674Z 658.11 false javascript.0 2022-10-15T20:30:20.771Z 651.61 false javascript.0 2022-10-15T20:30:23.545Z 648.61 false javascript.0 2022-10-15T20:30:25.550Z 650.91 false javascript.0 2022-10-15T20:30:27.572Z 656.31 false javascript.0 2022-10-15T20:30:29.588Z 650.11 false javascript.0 2022-10-15T20:30:32.497Z 650.41 false javascript.0 2022-10-15T20:30:34.523Z 651.21 false javascript.0 2022-10-15T20:30:36.576Z 654.61 false javascript.0 2022-10-15T20:30:39.545Z 653.41 false javascript.0 2022-10-15T20:30:42.500Z 651.11 false javascript.0 2022-10-15T20:30:45.506Z 655.01 false javascript.0 2022-10-15T20:30:47.507Z 648.81 false javascript.0 2022-10-15T20:30:49.564Z 651.21 false javascript.0 2022-10-15T20:30:52.496Z 653.71 false javascript.0 2022-10-15T20:30:54.525Z 650.61 false javascript.0 2022-10-15T20:30:57.493Z 649.21 false javascript.0 2022-10-15T20:31:00.497Z 655.11 false javascript.0 2022-10-15T20:31:02.503Z 681.21 false javascript.0 2022-10-15T20:31:04.545Z 651.01 false javascript.0 2022-10-15T20:31:06.557Z 650.51 false javascript.0 2022-10-15T20:31:09.534Z 650.31 false javascript.0 2022-10-15T20:31:12.499Z 647.41 false javascript.0 2022-10-15T20:31:14.520Z 660.91 false javascript.0 2022-10-15T20:31:17.497Z 654.11 false javascript.0 2022-10-15T20:31:19.497Z 651.31 false javascript.0 2022-10-15T20:31:21.563Z 652.21 false javascript.0 2022-10-15T20:31:24.495Z 656.61 false javascript.0 2022-10-15T20:31:27.493Z 650.91 false javascript.0 2022-10-15T20:31:29.493Z 651.41 false javascript.0 2022-10-15T20:31:31.494Z 651.31 false javascript.0 2022-10-15T20:31:33.501Z 652.91 false javascript.0 2022-10-15T20:31:36.565Z 652.01 false javascript.0 2022-10-15T20:31:39.545Z 650.31 false javascript.0 2022-10-15T20:31:42.487Z 652.71 false javascript.0 2022-10-15T20:31:44.490Z 649.21 false javascript.0 2022-10-15T20:31:47.481Z 653.51 false javascript.0 2022-10-15T20:31:49.522Z 663.41 false javascript.0 2022-10-15T20:31:51.525Z 658.01 false javascript.0 2022-10-15T20:31:54.490Z 658.81 false javascript.0 2022-10-15T20:31:57.499Z 660.51 false javascript.0 2022-10-15T20:32:00.522Z 657.61 false javascript.0 2022-10-15T20:32:03.487Z 656.41 false javascript.0 2022-10-15T20:32:05.489Z 655.21 false javascript.0 2022-10-15T20:32:07.491Z 658.21 false javascript.0 2022-10-15T20:32:10.534Z 656.91 false javascript.0 2022-10-15T20:32:13.502Z 657.38 false javascript.0 2022-10-15T20:32:16.475Z 654.18 false javascript.0 2022-10-15T20:32:18.481Z 655.48 false javascript.0 2022-10-15T20:32:21.543Z 655.58 false javascript.0 2022-10-15T20:32:24.483Z 657.88 false javascript.0 2022-10-15T20:32:26.500Z 659.28 false javascript.0 2022-10-15T20:32:28.740Z 661.78 false javascript.0 2022-10-15T20:32:31.475Z 653.98 false javascript.0 2022-10-15T20:32:33.490Z 655.38 false javascript.0 2022-10-15T20:32:36.571Z 655.68 false javascript.0 2022-10-15T20:32:39.481Z 658.98 false javascript.0 2022-10-15T20:32:41.490Z 659.18 false javascript.0 2022-10-15T20:32:43.522Z 658.08 false javascript.0 2022-10-15T20:32:46.497Z 653.18 false javascript.0 2022-10-15T20:32:49.499Z 655.68 false javascript.0 2022-10-15T20:32:51.585Z 665.18 false javascript.0 2022-10-15T20:32:54.586Z 656.08 false javascript.0 2022-10-15T20:32:58.490Z 656.68 false javascript.0 2022-10-15T20:33:00.499Z 660.08 false javascript.0 2022-10-15T20:33:03.473Z 656.38 false javascript.0 2022-10-15T20:33:05.473Z 658.28 false javascript.0 2022-10-15T20:33:08.470Z 656.68 false javascript.0 2022-10-15T20:33:10.473Z 657.48 false javascript.0 2022-10-15T20:33:13.492Z 657.48 false javascript.0 2022-10-15T20:33:16.476Z 660.78 false javascript.0 2022-10-15T20:33:18.477Z 660.88 false javascript.0 2022-10-15T20:33:21.146Z 660.58 false javascript.0 2022-10-15T20:33:23.767Z 667.88 false javascript.0 2022-10-15T20:33:26.548Z 667.08 false javascript.0 2022-10-15T20:33:29.463Z 684.38 false javascript.0 2022-10-15T20:33:31.463Z 663.28 false javascript.0 2022-10-15T20:33:34.489Z 655.88 false javascript.0 2022-10-15T20:33:37.461Z 658.08 false javascript.0 2022-10-15T20:33:39.464Z 654.98 false javascript.0 2022-10-15T20:33:42.460Z 652.28 false javascript.0 2022-10-15T20:33:45.464Z 656.98 false javascript.0 2022-10-15T20:33:47.470Z 645.98 false javascript.0 2022-10-15T20:33:49.487Z 648.78 false javascript.0 2022-10-15T20:33:52.456Z 659.28 false javascript.0 2022-10-15T20:33:54.456Z 642.08 false javascript.0 2022-10-15T20:33:56.459Z 664.98 false javascript.0 2022-10-15T20:33:59.464Z 655.78 false javascript.0 2022-10-15T20:34:01.465Z 662.88 false javascript.0 2022-10-15T20:34:04.460Z 657.98 false javascript.0 2022-10-15T20:34:06.632Z 669.68 false javascript.0 2022-10-15T20:34:09.452Z 652.18 false javascript.0 2022-10-15T20:34:11.452Z 647.81 false javascript.0 2022-10-15T20:34:13.463Z 649.11 false javascript.0 2022-10-15T20:34:16.457Z 649.81 false javascript.0 2022-10-15T20:34:18.457Z 654.11 false javascript.0 2022-10-15T20:34:20.483Z 658.81 false javascript.0 2022-10-15T20:34:23.516Z 650.11 false javascript.0 2022-10-15T20:34:26.448Z 645.31 false javascript.0 2022-10-15T20:34:28.451Z 643.31 false javascript.0 2022-10-15T20:34:31.456Z 654.61 false javascript.0 2022-10-15T20:34:34.450Z 642.21 false javascript.0 2022-10-15T20:34:37.455Z 650.61 false javascript.0 2022-10-15T20:34:40.447Z 647.81 false javascript.0 2022-10-15T20:34:42.448Z 644.31 false javascript.0 2022-10-15T20:34:45.454Z 644.51 false javascript.0 2022-10-15T20:34:48.453Z 647.11 false javascript.0 2022-10-15T20:34:51.444Z 649.71 false javascript.0 2022-10-15T20:34:53.466Z 648.81 false javascript.0 2022-10-15T20:34:56.445Z 650.21 false javascript.0 2022-10-15T20:34:58.449Z 645.11 false javascript.0 2022-10-15T20:35:00.451Z 643.51 false javascript.0 2022-10-15T20:35:02.596Z 647.11 false javascript.0 2022-10-15T20:35:05.443Z 643.31 false javascript.0 2022-10-15T20:35:07.444Z 640.31 false javascript.0 2022-10-15T20:35:10.497Z 643.31 false javascript.0 2022-10-15T20:35:13.454Z 640.71 false javascript.0 2022-10-15T20:35:16.440Z 672.01 false javascript.0 2022-10-15T20:35:19.452Z 668.11 false javascript.0 2022-10-15T20:35:22.439Z 670.61 false javascript.0 2022-10-15T20:35:25.442Z 668.71 false javascript.0 2022-10-15T20:35:27.445Z 666.71 false javascript.0 2022-10-15T20:35:30.443Z 671.81 false javascript.0 2022-10-15T20:35:33.444Z 669.01 false javascript.0 2022-10-15T20:35:36.437Z 688.61 false javascript.0 2022-10-15T20:35:38.462Z 703.91 false javascript.0 2022-10-15T20:35:41.434Z 712.41 false javascript.0 2022-10-15T20:35:43.463Z 714.91 false javascript.0 2022-10-15T20:35:46.438Z 692.01 false javascript.0 2022-10-15T20:35:48.439Z 693.21 false javascript.0 2022-10-15T20:35:50.466Z 691.31 false javascript.0 2022-10-15T20:35:53.443Z 694.21 false javascript.0 2022-10-15T20:35:56.439Z 697.41 false javascript.0 2022-10-15T20:35:58.451Z 690.81 false javascript.0 2022-10-15T20:36:01.436Z 690.31 false javascript.0 2022-10-15T20:36:03.446Z 696.21 false javascript.0 2022-10-15T20:36:06.428Z 693.31 false javascript.0 2022-10-15T20:36:09.443Z 699.21 false javascript.0 2022-10-15T20:36:12.432Z 696.61 false javascript.0 2022-10-15T20:36:15.434Z 696.61 false javascript.0 2022-10-15T20:36:18.429Z 653.91 false javascript.0 2022-10-15T20:36:20.462Z 656.81 false javascript.0 2022-10-15T20:36:23.431Z 883.51 false javascript.0 2022-10-15T20:36:26.429Z 882.91 false javascript.0 2022-10-15T20:36:28.455Z 884.31 false javascript.0 2022-10-15T20:36:31.426Z 707.21 false javascript.0 2022-10-15T20:36:34.453Z 690.01 false javascript.0 2022-10-15T20:36:37.424Z 695.01 false javascript.0 2022-10-15T20:36:40.467Z 694.51 false javascript.0 2022-10-15T20:36:43.449Z 696.11 false javascript.0 2022-10-15T20:36:46.420Z 699.41 false javascript.0 2022-10-15T20:36:48.420Z 695.71 false javascript.0 2022-10-15T20:36:50.459Z 693.01 false javascript.0 2022-10-15T20:36:53.430Z 697.91 false javascript.0 2022-10-15T20:36:56.419Z 688.81 false javascript.0 2022-10-15T20:36:58.450Z 461.11 false javascript.0 2022-10-15T20:37:01.425Z 460.81 false javascript.0 2022-10-15T20:37:04.442Z 464.11 false javascript.0 2022-10-15T20:37:07.426Z 464.11 false javascript.0 2022-10-15T20:37:10.418Z 460.41 false javascript.0 2022-10-15T20:37:12.426Z 460.31 false javascript.0 2022-10-15T20:37:15.424Z 468.81 false javascript.0 2022-10-15T20:37:18.422Z 461.81 false javascript.0 2022-10-15T20:37:20.443Z 460.31 false javascript.0 2022-10-15T20:37:23.412Z 463.81 false javascript.0 2022-10-15T20:37:25.412Z 460.51 false javascript.0 2022-10-15T20:37:27.473Z 465.81 false javascript.0 2022-10-15T20:37:30.420Z 463.71 false javascript.0 2022-10-15T20:37:33.412Z 457.71 false javascript.0 2022-10-15T20:37:35.437Z 463.91 false javascript.0 2022-10-15T20:37:38.413Z 460.51 false javascript.0 2022-10-15T20:37:40.422Z 459.91 false javascript.0 2022-10-15T20:37:43.413Z 702.61 false javascript.0 2022-10-15T20:37:45.413Z 704.91 false javascript.0 2022-10-15T20:37:47.413Z 703.21 false javascript.0 2022-10-15T20:37:49.416Z 703.01 false javascript.0 2022-10-15T20:37:51.425Z 702.71 false javascript.0 2022-10-15T20:37:54.412Z 698.51 false javascript.0 2022-10-15T20:37:57.405Z 704.71 false javascript.0 2022-10-15T20:38:00.412Z 706.41 false javascript.0 2022-10-15T20:38:02.416Z 707.91 false javascript.0 2022-10-15T20:38:05.403Z 672.61 false javascript.0 2022-10-15T20:38:08.410Z 671.61 false javascript.0 2022-10-15T20:38:10.415Z 674.81 false javascript.0 2022-10-15T20:38:13.408Z 669.48 false javascript.0 2022-10-15T20:38:16.419Z 669.08 false javascript.0 2022-10-15T20:38:19.406Z 433.98 false javascript.0 2022-10-15T20:38:22.402Z 660.88 false javascript.0 2022-10-15T20:38:24.417Z 674.48 false javascript.0 2022-10-15T20:38:27.406Z 678.08 false javascript.0 2022-10-15T20:38:30.397Z 698.88 false javascript.0 2022-10-15T20:38:32.400Z 699.48 false javascript.0 2022-10-15T20:38:34.401Z 698.38 false javascript.0 2022-10-15T20:38:36.401Z 704.38 false javascript.0 2022-10-15T20:38:39.407Z 701.58 false javascript.0 2022-10-15T20:38:42.403Z 760.58 false javascript.0 2022-10-15T20:38:45.394Z 745.68 false javascript.0 2022-10-15T20:38:47.396Z 708.58 false javascript.0 2022-10-15T20:38:50.400Z 715.78 false javascript.0 2022-10-15T20:38:52.413Z 711.68 false javascript.0 2022-10-15T20:38:55.395Z 702.98 false javascript.0 2022-10-15T20:38:57.398Z 590.18 false javascript.0 2022-10-15T20:39:00.408Z 469.38 false javascript.0 2022-10-15T20:39:03.394Z 461.78 false javascript.0 2022-10-15T20:39:05.398Z 468.48 false javascript.0 2022-10-15T20:39:07.400Z 467.48 false javascript.0 2022-10-15T20:39:10.391Z 461.38 false javascript.0 2022-10-15T20:39:13.396Z 455.58 false javascript.0 2022-10-15T20:39:15.400Z 473.48 false javascript.0 2022-10-15T20:39:18.389Z 460.68 false javascript.0 2022-10-15T20:39:20.389Z 459.28 false javascript.0 2022-10-15T20:39:23.396Z 462.08 false javascript.0 2022-10-15T20:39:24.393Z 488.78 false system.adapter.javascript.0 2022-10-15T20:39:25.395Z 459.08 false system.adapter.javascript.0 2022-10-15T20:39:26.388Z 457.98 false system.adapter.javascript.0 2022-10-15T20:39:27.383Z 458.58 false system.adapter.javascript.0 2022-10-15T20:39:28.387Z 460.58 false system.adapter.javascript.0 2022-10-15T20:39:29.394Z 464.68 false system.adapter.javascript.0 2022-10-15T20:39:30.393Z 461.58 false system.adapter.javascript.0
Hey! Du scheinst an dieser Unterhaltung interessiert zu sein, hast aber noch kein Konto.
Hast du es satt, bei jedem Besuch durch die gleichen Beiträge zu scrollen? Wenn du dich für ein Konto anmeldest, kommst du immer genau dorthin zurück, wo du zuvor warst, und kannst dich über neue Antworten benachrichtigen lassen (entweder per E-Mail oder Push-Benachrichtigung). Du kannst auch Lesezeichen speichern und Beiträge positiv bewerten, um anderen Community-Mitgliedern deine Wertschätzung zu zeigen.
Mit deinem Input könnte dieser Beitrag noch besser werden 💗
Registrieren Anmelden598
Online32.9k
Benutzer83.0k
Themen1.3m
Beiträge