1 2 Previous Next 16 Replies Latest reply on Oct 14, 2016 3:21 PM by ichanjasper Go to original post
      • 16. Re: Slowness while deploying VDB.
        ichanjasper
        ichanjasper Oct 14, 2016 3:21 PM (in response to shawkins)

        Interesting founding.

         

        If I use progress driver with CatalogOptions=0, total deployment time goes down from 2 minutes to 30 second.

         

        2016-10-14 10:58:47,522 DEBUG CONNECTOR,http-apr-8080-exec-8:67 - JDBCMetadataProcessor - Importing tables

        2016-10-14 10:58:47,620 DEBUG CONNECTOR,http-apr-8080-exec-8:67 - JDBCMetadataProcessor - Importing columns

        2016-10-14 10:58:48,203 DEBUG CONNECTOR,http-apr-8080-exec-8:67 - JDBCMetadataProcessor - Importing primary keys

        2016-10-14 10:58:50,018 DEBUG CONNECTOR,http-apr-8080-exec-8:67 - JDBCMetadataProcessor - Importing index info

        2016-10-14 10:58:58,834 DEBUG CONNECTOR,http-apr-8080-exec-8:67 - JDBCMetadataProcessor - Importing foreign keys

        2016-10-14 10:59:13,278 DEBUG CONNECTOR,http-apr-8080-exec-8:67 - JDBCMetadataProcessor - Importing tables

        2016-10-14 10:59:13,376 DEBUG CONNECTOR,http-apr-8080-exec-8:67 - JDBCMetadataProcessor - Importing columns

        2016-10-14 10:59:13,924 DEBUG CONNECTOR,http-apr-8080-exec-8:67 - JDBCMetadataProcessor - Importing primary keys

        2016-10-14 10:59:14,211 DEBUG CONNECTOR,http-apr-8080-exec-8:67 - JDBCMetadataProcessor - Importing index info

        2016-10-14 10:59:17,659 DEBUG CONNECTOR,http-apr-8080-exec-8:67 - JDBCMetadataProcessor - Importing foreign keys

        2016-10-14 10:59:17,924 DEBUG VirtualDataSourceQueryService,http-apr-8080-exec-8:247 - Deployment time for virtual data source, -2146727971: 30639ms

         

        If I use native oracle driver, total deployment time is 61 second.

         

        2016-10-14 12:15:35,941 DEBUG CONNECTOR,http-apr-8080-exec-9:67 - JDBCMetadataProcessor - Importing tables

        2016-10-14 12:15:36,065 DEBUG CONNECTOR,http-apr-8080-exec-9:67 - JDBCMetadataProcessor - Importing columns

        2016-10-14 12:15:43,148 DEBUG CONNECTOR,http-apr-8080-exec-9:67 - JDBCMetadataProcessor - Importing primary keys

        2016-10-14 12:15:46,389 DEBUG CONNECTOR,http-apr-8080-exec-9:67 - JDBCMetadataProcessor - Importing index info

        2016-10-14 12:15:56,640 DEBUG CONNECTOR,http-apr-8080-exec-9:67 - JDBCMetadataProcessor - Importing foreign keys

        2016-10-14 12:16:27,462 DEBUG CONNECTOR,http-apr-8080-exec-9:67 - JDBCMetadataProcessor - Importing tables

        2016-10-14 12:16:27,562 DEBUG CONNECTOR,http-apr-8080-exec-9:67 - JDBCMetadataProcessor - Importing columns

        2016-10-14 12:16:30,472 DEBUG CONNECTOR,http-apr-8080-exec-9:67 - JDBCMetadataProcessor - Importing primary keys

        2016-10-14 12:16:31,112 DEBUG CONNECTOR,http-apr-8080-exec-9:67 - JDBCMetadataProcessor - Importing index info

        2016-10-14 12:16:36,280 DEBUG CONNECTOR,http-apr-8080-exec-9:67 - JDBCMetadataProcessor - Importing foreign keys

        2016-10-14 12:16:36,852 DEBUG VirtualDataSourceQueryService,http-apr-8080-exec-9:247 - Deployment time for virtual data source, -587597697: 61361ms

         

        But deployment vdb in oracle is still way slower than postgres.

          • Actions
        1 2 Previous Next