Chapter 14 Reverse Engineering a Database into a PDM

Optimizing ODBC reverse engineering queries

ODBC reverse engineering has been optimized in order to improve performance. All ODBC queries run according to an optimization process rule. This process uses the following registry keys:

• RevOdbcMinCount defines a number of selected objects for reverse engineering. The default number is 100
• RevOdbcMinPerct defines a percentage of selected objects for reverse engineering. The default percentage is 10

These keys do not exist by default, you have to create and edit them in the Registry under:

Current User \Software\Sybase\PowerDesigner 11\FolderOptions\Physical Objects

During reverse engineering, PowerDesigner compares the total number of current objects for reverse engineering to the value of RevOdbcMinCount.

If the total number of listed items is lower than the value of RevOdbcMinCount A global reverse query is executed.

If the total number of listed items is higher than the value of RevOdbcMinCount The process uses key RevOdbcMinPerct.

• If the percentage of reversed items is lower than the percentage defined in RevOdbcMinPerct, then a global query is executed
• If the percentage of reversed items is higher than the percentage defined in RevOdbcMinPerct, then the same query is executed for each object

Copyright (C) 2006. Sybase Inc. All rights reserved.