B4J Question SQlite file update

Discussion in 'B4J Questions' started by derez, Sep 12, 2015.

  1. derez

    derez Expert Licensed User

    When a server runs an SQL Database and updates it during interface with users, when a user downloads the DB file from the server, does the file include all the updates ? In other words, does the server updates the file on which it was initialized while it is still in work ?
  2. Daestrum

    Daestrum Well-Known Member Licensed User

    If I understand your question correctly, you have a database that is in use. A user downloads the database file whilst it is still in use. Does it contain all the information that the original file contained?

    The simple answer is 'possibly most of it' ,depending on the server, you may have indexes which have not been written/updated, also entire transactions may be missing, due to the database software using delayed writes to disk for indexes and records. It won't contain any transactions that are in progress when the copy is taken.
  3. derez

    derez Expert Licensed User

    If I download the file 2 minutes after the last update had been done - will it be completely updated ?
  4. Erel

    Erel Administrator Staff Member Licensed User

    Are you asking about SQLite?
    1. Make sure that there is no active transaction when you download the database.
    2. Download the journal files as well as the database file (if such are available).
  5. derez

    derez Expert Licensed User

    Thank you
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice