About SQL Partitioning

Note: To have the ability to partition tables, you must be running SQL Server, Enterprise Edition.

Why partition SQL database tables? It improves performance. Partitioning larger tables allows the application to search less data, and therefore partitioning helps speed the performance of searches and page-loads that require netFORUM to scan the table in its entirety.

About SQL Partitioning in netFORUM

You have always been welcome to partition SQL database tables that netFORUM uses, but until now SQL partitioning has been invisible to netFORUM. In 2015.1, netFORUM checks if a table is partitioned on its xxx_add_date field. If it finds this specific partitioning, netFORUM automatically filters all the Find and List pages in iWeb to use the most recent partition.

If you are a database administrator, then the decision to partition rests with you. Abila can provide you scripts that will create table partitions based on the table's xxx_add_date. Consider your decision and plan accordingly. In your partition plan, also include a maintenance plan. Ask yourself the following questions:

Note: Abila is available to help you during this planning stage. Please contact Abila to help you navigate the decision and to help you execute the partitioning.

When you run the scripts, the partitioning process itself can take hours, depending on the size of the original table and the number of partitions. Once the data is reorganized, netFORUM's iWeb List pages will only show records from the most recent partition. iWeb Find pages that search the partitioned table will show an extra check box: Limit results to records added on or after [date] where [date] is the mm/dd/yyyy of the most recent partition. netFORUM modifies the List and Find pages automatically in versions 2015.1 and 2015.1, no need to change any iWeb settings.