Book a Demo
« previous next »
Pages: [1]

Author Topic: Transactions  (Read 5131 times)

rvaldes

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Transactions
« on: October 20, 2010, 08:06:53 pm »
Hi,

is possible to perform a transaction begin/commit/rollback using Automation Interface?

How AI handles connections to database? It opens a new connection by every SQL DML generated calling the API functions? Or an unique connection is mantained for all?

My point is that sometimes i have a large set of data to insert or delete from repository and it seems that the performance is very poor ...
Logged

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Transactions
« Reply #1 on: October 20, 2010, 08:10:45 pm »
see http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1287185419
I don't think you can do transactions, but the batchAppend setting might be similar.

Geert
Logged
Pages: [1]
« previous next »