Database size

  1. 2 years ago

    Hi everyone,

    I am starting to get quite a bit of data in the PIM now (well, quite a bit to me) and plan to add a lot of data all over the Christmas holidays etc.

    Chris (writer of doogiePIM) tells me the database is based on a proprietary system compatible with a SQL-92 database engine (although I'd like to know more about the database engine).

    However, I have no experience with database size.

    Does anyone have a really large database and can share their experiences on size and speed?

    If the database is the same as it was for do-organiser / Harmony, can anyone shed any light on the size of their databases?

    Over time, I will add a lot of data to the PIM, so would like to know it is going to be able to handle it in a safe manner.

    Any advice would be welcome.

    Many thanks.


  2. last year


    13 Feb 2018 Developer, Moderator, Beta Tester
    Edited last year by Chris

    This one was left unanswered so here goes:

    Warning: Geek Speak ahead!

    Database, Encryption and Size

    The database system used is a SQL-92 compatible proprietary structured build. You are able to use SQL commands to extract data.

    More here:

    A SQL command summary can be found here:

    Specifications can be found in the Help documentation:

    This basically means you can add a lot of data. The file size of the database should grow to a practical maximum of about 3GB to 4GB. However, it can go larger but backups and indexing will take much longer. Records such as documents and comments are internally packed using compression then each record block is encrypted using the chosen encryption method. This makes the database compact.

    I have databases that are 12GB, 6.5GB and 1.5GB. Each contain a variety of records. The 12GB file contains mostly Documents with many images. The 1.5GB file is my daily use email, tasks, documents etc.

    To summarise; Keep it small for faster backups for daily use but if you just want to store a bunch of stuff to file away, then load it up.

    I hope others will write in and tell of their experiences and file sizes too. It would be great to gauge if this area needs development or not.

    As always, many thanks for the wonderful emails and messages on doogiePIM.

  3. Hi Chris, does the above still stand for v2?
    I take it the database has remained unchanged from v1 to v2?


  4. Chris

    16 Mar 2018 Developer, Moderator, Beta Tester

    @J-Hinckley Hi Chris, does the above still stand for v2?
    I take it the database has remained unchanged from v1 to v2?

    Yes, the specifications in the above post are for version 1 and version 2. The latest databases schedule in v2 has encryption changes to improve security as well as some field data changes. Therefore, Version 1 database will open in version 2 but version 2 databases won't open in version 1.

    This ensures that old backup files open correctly, with the latest doogiePIM.

    If you plan to go back to version 1 then always open databases in version 2 with a COPY of your database. This is because once converted in v2 you can't use doogiePIM v1 to open it. This is by design.

    I hope this has answered your question.


  5. Thanks Chris


or Sign Up to reply!