Views:
Question:
Is there a limit to how many index fields a File cabinet can have in it?
 
Answer:
Commencing in DocuWare version 6.8, there is no set limit to the amount of index fields that can go into a file cabinet.
 
Note: The more fields, the more database resources and maintenance that need to be done to keep up with the load.
 
KBA is applicable for both Cloud and On-Premise Organizations.

 
This article is valid for DocuWare versions: 6.8 6.9 6.10 6.11 6.12 7 7.1 7.2 7.3 7.4 7.5, DWCloud | limit to amount of index fields
Comments (2)
  • Jason Scott
    Tue, 07 Dec 2021 03:46:33 GMT
    This is not true. There is a limitation of the amount of table columns for different database engines. 

    In MSSQL as well as DocuWare Cloud, there is a limit of 1024 columns. 

    If you attempt to create more than 1024 columns in DocuWare Cloud, you will receive an error like this

    Start
  • Jason Scott
    Tue, 07 Dec 2021 03:49:10 GMT
    CREATE TABLE failed because column 'FIELD_X' in table 'File_Cabinet_X' exceeds the maximum of 1024 columns.