Graphics

"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
------------------------------

Are you facing issues? 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------

Yes. I saw some strange behaviors as follows.

• As far as seeing Preview on the Sequence, correct values given by Datalinq server were inserted in the scene, but different values (which was entered previously) were inserted on the actual output.
• It seemed like entire system performance was getting slow, scenes could be changed after hitting take in the sequence.

I tried restarting entire system, and I deleted the Datalinq setting (ADODB, Excel, refresh every second) just to be safe, then no problem seen after it. Although I haven't narrow down the cause of issue yet.

------------------------------
Takuya Hoshikaya
------------------------------

Original Message:
Sent: 10-24-2024 08:14
From: Simon Redmile
Subject: How many seconds would be reasonable for ADODB Datalinq option to read Excel

Are you facing issues? 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------

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+) 

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+)