Re: Accessing another DB with Logging

"Art S. Kagel" <kagel@bloomberg.com> writes: > You could also use separate connections one for each database. I have > not yet tried to create and ESQL/C function set to set and switch from > one connection to another but it works great in ESQL/C alone. Indeed, > I have found that the rewitten programs using separate connections for > accessing each remote database actually runs faster than accessing > those databases from one connection as remote selects. Yes, but be aware that you then of course loose transactional integrity between the two databases (which would be hard to get with one of the dabases running without logging anyway). The speedups are probably due to the databases not having to exchange transaction information. -- 'yvind Gjerstad Systems dept Tollpost-Globe AS N-6301 'ndalsnes/Norway E-mail: ogj@it.tollpost.no Phone: +47 7122 6663 Fax: +47 7122 6694