Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
3 years ago

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 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
------------------------------
  • 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's avatar
      PaulPeterson1
      Qrew Assistant Captain
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Then cross app is the way to go.

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