Thank you for the comment, I think, as of right now, I will leave the value at "0".
My graphic is for soccer games, there are a lot of text objects in the player's roster, score, substitutions, etc.. I should learn more about the workflow with Datalinq and should sort out my workflow. And will start consideration using Dashboard.
------------------------------
Takuya Hoshikaya
------------------------------
Original Message:
Sent: 10-24-2024 15:52
From: Garner Millward
Subject: How many seconds would be reasonable for ADODB Datalinq option to read Excel
If you are not having issues with data refresh, you should leave it at 0. XPression will ask Datalinq to query the database at the time the graphic is prepared for playout (when you hit TAKE in the Sequencer on a take item). Operating like this should work for the majority of systems installs. Typically we only see data refresh issues when the database is very slow to respond to queries (2-3 seconds or higher), or if the XPression graphic has a lot of text objects that run queries (10-40+)
Original Message:
Sent: 10-23-2024 23:58
From: Takuya Hoshikaya
Subject: How many seconds would be reasonable for ADODB Datalinq option to read Excel
"Refresh Every: xx seconds" option in the ADODB Datalinq configuration is very useful. But still I would like to hear some suggestions for how many seconds should it be set to
One second would be great since it force Datalinq to read Excel file every second. But I have a concern about the network load issue, although my Excel file is small, only 3 to 4 MB. I'd like some advice.
------------------------------
Takuya Hoshikaya
------------------------------