Sync Table 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 u...
Forum Discussion
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
------------------------------
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
------------------------------
The delay could be an issue. If changes are made in the third party data, the session token must be updated. A delay would impact the data transfer.
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------
- Then cross app is the way to go.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- 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. In an ideal situation the token is only updated once per day.
------------------------------
Paul Peterson
------------------------------- 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
------------------------------
