|
1. Improved export of inventory graphs, load graphs, and working patterns (maintenance contract required)
Inventory graphs, load graphs, and working patterns can now be exported using DBIO. This will now allow you to export the above to programs like Microsoft SQL Server and Excel.
| Starting from this version you are now able to generate tables of inventory graphs, load graphs, and working patterns. |
|
| When these commands are executed, the table will be generated based on the style specified in the command. The figure on the right shows the generated load graph table. |
|
| In the “Data Input/Output Tables” section, DBIO objects for three tables are provided, which can be exported to OLE DB or text files in the same way as other tables. |
|
|
|
In addition, the export menu for the Resource Gantt Chart, Load Graph, and Inventory Graph has each been added to the right-click menu at the corner box.
There was a similar menu in [Chart]-[Load Graph], but we removed it after users’ comments that it was difficult to find where it was.
|
2. DBIO export acceleration (maintenance contract required)
After increasing the speed of exporting to Microsoft SQL Server and Oracle Database in Ver. 16.2, the speed of exporting to PostgreSQL and text files has also been increased.
PostgreSQL
The speedup works for all versions of PostgreSQL. For DBIO settings, the “SQL command type” property must be set to “Full text”. With this update “Full text” will be much faster than “Parameter”. The following are the test results within the same LAN network. INSERT and UPDATE processes in the database are grouped together to speed up the process.
| Export |
Table |
Number of objects |
Ver.16.2 [sec] |
Ver.16.3 [sec] |
Increased speed |
| No difference |
Order |
20,000 |
20.96 |
1.89 |
Approximately 11 times |
| Operation |
100,000 |
108.47 |
11.50 |
Approximately 9.4 times |
| Differential |
Order |
20,000 |
22.03 |
2.72 |
Approximately 8.1 times |
| Operation |
100,000 |
116.57 |
15.56 |
Approximately 7.5 times |
|
No difference |
Differential |
| Table |
Order |
Operation |
Order |
Operation |
| Primary key |
Order code |
Operation code |
Order code |
Operation code |
| Number of mapped property |
10 |
10 |
10 |
10 |
| Export |
Yes (all) |
Yes (all) |
Yes (differential) |
Yes (differential) |
| Clear table before export |
Yes |
Yes |
No |
No |
Deleted objects
Export |
Yes (primary key) |
Yes (primary key/delete records) |
Yes (primary key) |
Yes (primary key/delete records) |
| Number of objects deleted. |
10 |
50 |
10 |
50 |
Text file
Test 1
| Export |
Table |
Number of objects |
Ver.16.2 [sec] |
Ver.16.3 [sec] |
Increased speed |
| SSD (ASU800SS-240GT-IT-B) |
Order |
90,000 |
1.36 |
0.64 |
Approximately double |
| Operation |
330,000 |
5.45 |
2.42 |
Approximately double |
| Peg |
300,000 |
2.46 |
1.22 |
Approximately double |
| HDD (ST2000DM005-2CW102) |
Order |
90,000 |
1.40 |
0.66 |
Approximately double |
| Operation |
330,000 |
5.46 |
2.44 |
Approximately double |
| Peg |
300,000 |
2.43 |
1.21 |
Approximately double |
| Table |
Order |
Operation |
Peg |
| Number of mapped property |
26 |
23 |
7 |
| Export |
Yes (all) |
Yes (all) |
Yes (all) |
| File size after export |
11MB |
58MB |
35MB |
OS : Windows 10 Pro (64bit) CPU : Inter® Core TM i7-8700@2.30GHz Physical Memory : 16GB
Test 2
| Export |
Table |
Number of objects |
Ver.16.2 [sec] |
Ver.16.3 [sec] |
Increased speed |
| SSD (ASU800SS-240GT-IT-B) |
Order |
10,100,000 |
169.02 |
81.57 |
Approximately double |
| Message |
10,000,000 |
25.67 |
13.17 |
Approximately double |
| HDD (ST2000DM005-2CW102) |
Operation |
10,100,000 |
172.09 |
84.24 |
Approximately double |
| Message |
10,000,000 |
25.98 |
13.23 |
Approximately double |
| Table |
Order |
Operation |
| Number of mapped property |
12 |
2 |
| Export |
Yes (all) |
Yes (all) |
| File size after export |
1.7GB |
800MB |
OS : Windows 10 Pro (64bit) CPU : Inter® Core TM i7-8720X@3.60GHz Physical Memory : 128GB
3. Display color of style tab (maintenance contract required)
|
|
Added the ability to change the display color of the style tab. You can set the display color by clicking the right-click pop-up menu “Style tab background color” or “Style tab font color” on the tab.
The specified settings will be set to the [Style tab background color] and [Style tab font color] properties. These two properties can be saved without having to overwrite the default style. |
4. High DPI support
When using Asprova on a high DPI monitor, the text and menus may look blurry. This also happens when a normal DPI monitor is used together with a high DPI monitor. This problem could have been handled by changing the application settings on the OS, but from this version it is now handled automatically.
Ver.16.2
Ver.16.3
5. Increased speed
Asprova’s loading times have been reduced. The loading time of project files has been reduced and there is a slight speed-up in processes such as expression evaluations, imports, and outputting a large number of messages.
6. Changes
When renewing Asprova MES’s protector, administrator priviledges are now no longer required from now on. |
