User forums now online! Please see the latest post in the Announcements forum for more information.

Author Topic: ThumbsPlus Database choices  (Read 535 times)

0 Members and 2 Guests are viewing this topic.

Laura Shook

  • Administrator
  • Sr. Member
  • *****
  • Posts: 141
    • View Profile
ThumbsPlus Database choices
« on: 2019-02-22 14:18:44 »
There is a lot of information about your ThumbsPlus database choices below but it is easy to understand and implement!

The default ThumbsPlus v10 database:

When you first install ThumbsPlus, the default ThumbsPlus v10 database that is used has a 2Gb size limit. (However, for quite some time there have been several ways to configure and/or use other databases or other database options that will allow for either a larger thumbnail count capacity - even when using the default database, or a database without a size limit. More information about this is copied below.)

The current ThumbsPlus default database is an MS Access database with a .tpdb8 extension. In ThumbsPlus v10 build 4015, the following (default) database settings allow for approximately 400,000 thumbnails (if you do NOT use the database option to "store thumbnails in files" that is described further down.)

160 x 160 sized thumbnails
True color (24-bit)
JPEG quality 80%

The amount of thumbnail data that is assigned, (keywords, annotations, udf's, etc..) does have an impact on your database size as well. We have found that when there is a HUGE number of keyword references, this will increase the space used significantly.

ThumbsPlus PRO and Home Network licensed users with non-networked databases, (and those evaluating ThumbsPlus) can begin again with a new database that will store millions of thumbnails using either of the options below.

Creating a new database:

Note that either of these new database choices give you the option to create larger, prettier thumbnails as well without "filling" the database too quickly. (Examples of thumbnail sizes are shown in the first attached image.


To create a new database go to Database>New.

1. Creating the NEW database using the "Thumbnails in files option".

Configuring a new database using the option to "store thumbnails in files" increases the  thumbnail count capacity giving you the room to store between 6 and 7 million thumbnails and their associated data!

The option to store the thumbnails in files, instead of storing the thumbnails in the database itself, stores the thumbnails in a file that resides in the same folder that houses the database. This does increase the amount of space needed for the thumbnail/data storage, but gives you the ability to manage much larger quantities of thumbnails in a single database.
 
2. In ThumbsPlus v10 SP2 the option to create an SQLite3 database has been improved greatly. To create a new SQLite3 database, choose this option when creating a new database. This type of database has NO SIZE limit except for your amount of disk space. The database extension of a SQLite3 database is .tpdb8s.

There are many ThumbsPlus users that are choosing this SQLite3 database option - and using it very successfully - with the latest v10 build due to the many changes we have recently made. (Note that running multiple thumbnail creation threads at the same time may give errors that will not have an impact on the stability of your database but may be annoying.)

I have attached 2 images that illustrate the steps to take to create one of these new database types.

3.  For corporations with ThumbsPlus Network licenses that have huge archives of images, there are database options other than the ThumbsPlus default databases of .tpdb8 (MS JET) or .tpdb8s (SQLite3). Advanced knowledge of client server database applications such as SQL Server, MYSQL, MariaDB, etc... is recommended for those that wish to use another client server database.

There is more information about using other Client/Server databases with ThumbsPlus here:
http://www.thumbsplus.com/databases.html

ThumbsPlus.com
support@thumbsplus.com
« Last Edit: 2019-05-03 15:29:51 by Laura Shook »