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

Author Topic: ThumbsPlus database choices  (Read 225 times)

0 Members and 1 Guest are viewing this topic.

Laura Shook

  • Administrator
  • Sr. Member
  • *****
  • Posts: 107
    • View Profile
ThumbsPlus database choices
« on: 2018-05-22 13:40:25 »
ThumbsPlus v10 has several different options for creating new databases that are a little different than the default options.

There is a lot of information below but it is easy to understand. Creating a new database with different options is not difficult either!

Out of the box the ThumbsPlus v10 database 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 MS Access database), or a database without a size limit.

Below you will find information about the database choices you have so that you can make the best decision for your specific needs.

The default ThumbsPlus 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:

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.

DATABASE SIZE:

If you wish to start from the beginning with a database that will store millions of thumbnails, you can start from scratch with a brand new database.

Creating a new database:

Either of these new database choices give you the option to create larger, prettier thumbnails as well without "filling" the database too quickly.

If you don't have keywords, annotations, udf's, off line thumbnails or galleries that are important to you, starting new is a great option as you can configure your new ThumbsPlus database in different ways.

To create either of the 2 new database options below, start by going 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! (This gives you the option to create larger, prettier thumbnails as well without "filling" the database too quickly.)

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 the ability to manage much larger quantities of thumbnails in a single database. This type of database is suggested for databases that are not shard on a Network.

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 except for your amount of disk space, but it does have its quirks.

There are many ThumbsPlus users that are choosing this SQLite3 database option with the latest v10 build and they are very happy to have this working option. (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 creating these types of databases.

3. There are additional database options for corporations that will be sharing a ThumbsPlus database over a company network. This option allows for the use of another client server database such as SQL Server.

Note that using another client server database is suggested only for those ThumbsPlus users with ADVANCED knowledge of client server database applications.
« Last Edit: 2019-01-10 14:49:03 by Laura Shook »