So the remote desktop software works great for V6. I can’t say the same for Autocad. You can’t run Autocad from a server so you can’t use the remote desktop software for it. Since most of our implementation involves automating Autocad with the data from V6, that is causing a problem.
We have a custom Microsoft Access program that uses the data from V6 to drive most of our downstream processes. Reporting, extrusion optimizations, Autocad Cleanup, fabrication drawings, etc… The program works fine in the Fremont office where we also have the SQL server, but the latency in the other offices when working over the network was a real issue. We spent the week testing different data access methods and found some interesting things. If you try to copy data from SQL over the network to a linked table, the performance is horrible. If you copy the same data to an unlinked table, it is much better. The best performance came from using stored procedures or pass-through queries to fill a non-linked tab …
July 3, 2010
