2010-07-12
QPL Reference Manual

If you find you need to increase the maximum number of content analysis tags after you have deployed your project and begun your analysis, you may follow the example below to build an SQL script that will alter your project's data base to add more tags. After you run this script on your server you will be able to define more topic tags.

You should replace the database name "job" used in the example with the name of your project.

# update.sql
# This script increases the maximum number of content analysis topic tags
# from the default of 256 to a new maximum of 512 tags.

USE job;

# Change the maximum setting in the info table.

UPDATE info SET q_max_ca_tags=512;

# Add 32-bit integer blocks to the ca_ques_def table. 
# Note: Integers must be named consecutively starting at t8 (t0 though t7 are already defined).

ALTER TABLE ca_ques_def
  ADD t8 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t9 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t10 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t11 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t12 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t13 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t14 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t15 INT4 UNSIGNED NOT NULL DEFAULT 0;

# Add 32-big integer blocks to the ca_assign table.

ALTER TABLE ca_assign
  ADD t8 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t9 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t10 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t11 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t12 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t13 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t14 INT4 UNSIGNED NOT NULL DEFAULT 0,
  ADD t15 INT4 UNSIGNED NOT NULL DEFAULT 0;

After this script is run, your data base will contain 16 32-bit integer blocks, named t0 through t15, giving you a total of 16 x 32 = 512 maximum topic tags.

You may follow this model to add up to a grand maximum of 3,200 topic tags.