How does Track Magic work behind the scenes?
Track Magic Pro and Track Magic Lite are implemented using Panorama (ProVUE Development’s ultra-fast RAM based database engine, see below) and Ruby. For high performance Track Magic Pro uses Panorama to keep a mirrored RAM based copy of the Rails tables you want to work with. Changes made to the RAM based mirror are automatically uploaded back to the SQL server thru Active Record. By using a RAM based mirror Track Magic facilitates advanced high speed searching, rapid “en masse” data modifications, and powerful analysis/reporting tools including cross tabulation and interactive data outlines. The diagram below illustrates how Panorama and Track Magic interact with your Ruby on Rails applications. Panorama and Track Magic are bundled together so you get both in one download and at one low price.
