Consultor Eletrônico

Screen of the plug-in responsible for generating the ranges that will be used in the parallel execution of programs in the Datasul product conversion and Concept unification, significantly reducing the amount of time this process takes.

Access the Table Partitioner plug-in through the Product Environment Management Console.

When you open the Console, at the top left corner, find the access to the Plug-ins. For a new one, click 'Get new plug-in' and select the tblPart plug-in.

After the download, go back to the Plug-in screen, select 'Table Partitioner' and click Run.

We recommend you to first perform a dbanalys on your environment to identify which are the largest tables, because you will obtain the highest gain by partitioning them.
The detailed procedure to perform dbanalys is included in the Progress kbase:
https://cat.totvs.com.br/eConsultor/Pesquisa/kbase_det.aspx?kbid=12436

Multi-company environment:
Select this field when the environment has a multi-company structure, with database duplication. In this format, you need to separately create the ranges for each company (mono databases) you wish to to partition.

Multi/single-database creation:
Field activated when you select option "multi-company environment". Use it to filter the mono/multi databases, so you can create files separately.

Tables available:
Displays a list with the tables you can partition.

Connection:
Enter the full string for connection to the database selected in the browser. You can use client-server, shared-memory or single-user connections.

Records interval:
Enter the quantity of records to be created in each range. The minimum limit for each range is 10,000 (ten thousand) record.

Generate:
Connects the database, in accordance with the parameters entered in field "connection", and creates the ranges based on the quantity of records entered. After creating them, the browser is updated with the quantity of ranges created.

Delete:
Deletes the creation selected.

Help:
Access the kbase with the plug-in documentation.

File:
Enter the file destination where the ranges created will be saved, or the file path from which the ranges saved previously will be imported. It is important to change the file name in multi-company creations.

Save:
Save the information created onscreen in a file. The file created is used later in the Update Console.

Import:
Import to the screen the information previously created on file. All current information onscreen are deleted.