ODBC Stage Performance
Posted: Fri Jun 13, 2003 4:31 am
When writing to multiple ODBC tables on the same database (Oracle), is there any performance advantage by using just 1 ODBC stage and having all links point to that stage? This can get somewhat unwieldy when 15-20 links point to the same stage.
The flip side would be a dedicated ODBC stage for each table. However this can cause maintainance problems and hogs screen space.
Does each ODBC stage create its own DB connection? If so, is this a potential performance problem?
The interfaces are run nightly with around 500,000 rows per night across a distributed network.
Any wisdom will be greatly appreciated [:)]
Simon
The flip side would be a dedicated ODBC stage for each table. However this can cause maintainance problems and hogs screen space.
Does each ODBC stage create its own DB connection? If so, is this a potential performance problem?
The interfaces are run nightly with around 500,000 rows per night across a distributed network.
Any wisdom will be greatly appreciated [:)]
Simon