Crash Magic Online
  Intersection Magic
  Map Magic
  Knowledge Base
  Contact Us


Knowledge Base Article:CMO180 

Registration keys moved to client area: Select login on the left menu bar.

Search home page  

MagicAuto performance issue identified.

Article created: Aug 11 2006, updated: Aug 11 2006

Background:  Pd' Programming has identified a potential problem in the MagicAuto processing in Crash Magic Online. We are investigating and will post a knowledgebase article as soon as we have isolated it.
The problem does not affect data accuracy. It is a performance issue that may affect users of Crash Magic Online when using the MagicAuto feature to call the program from a 3rd party application.

Status:  Bug - under investigation
Keywords:  MagicAuto,Transaction,table lock
Categories:   *Errors / crashes* *Related software*


The problem is a performance issue that could cause lengthy delays when anyone is using the MagicAuto functionality. (i.e. Map Magic plugin for ArcGIS)  The delays may be experienced by any user of Crash Magic Online while another user is creating a new diagram using MagicAuto.

The problem we've identified involves the way in which MS SQL Server handles table locking when using transactions.  Crash Magic Online opens a "transaction" when preparing to create an automated report using MagicAuto.  That transaction "wraps" the use of several tables in the system.  Once this transaction is begun those tables appear to become unavailable for other users until the transaction is "committed".  Since some of those tables are integral to the use of the program, it may become impossible to navigate Crash Magic until the MagicAuto diagram request is completed.

At this time, it does not appear that installations using Oracle's SQL server will experience this problem.


We are currently working on both short term and long term fixes for this problem and we will keep you posted.  You do not need to take any action at this time, and you may continue to use the program as you have been.

October 22, 2019 11:35PM

© 1999-2019 Pd' Programming, Inc - Lafayette, CO USA