Sync Table Question

Question

I have a table that holds session tokens for a third party app. This third party app will now be used with another app I administer. Would it be a good idea to move the current table to the app I use for data transfers and create a sync table in the two apps that will need access to the session token rather than creating cross app relationships?

I look forward to hearing your thoughts

------------------------------
Paul Peterson
------------------------------

I look forward to hearing your thoughts------------------------------Paul Peterson------------------------------

markshnier__you · Answer

In general a Sync table is a better practice than cross app relationship. That way the two apps will run in separate server processes and you will get better performance.

The Tokens are probably very stable data and even though the Sync table may be up to one hour behind it's probably good enough for your purposes.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

paulpeterson1 · Answer

The delay could be an issue.&nbsp; If changes are made in the third party data, the session token must be updated.&nbsp; A delay would impact the data transfer.------------------------------Paul Peterson------------------------------

markshnier__you · Answer

Then cross app is the way to go.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

paulpeterson1 · Answer

The other option is to recreate the table in the other app and add a couple of steps to the pipelines that update the token.&nbsp; In an ideal situation the token is only updated once per day.------------------------------Paul Peterson------------------------------

markshnier__you · Answer

I always worry that a pipeline will fail and the tables will get different. But you can run a daily midnight pipeline to wipe the mirror table and repopulate it.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Sync Table Question