Re: SE -vs- Online

Miguel A. Caldera (mac@antares-dev.com) wrote: : > If you have switched from SE to OnLine please answer these easy : > questions: : > : > 1. How much of a performance improvement did you see? : > 2. How easy/hard was it to do? : > 3. What would you say to someone that was considering doing this? : > Thanks in advance. : > : > Martin : > : > -------------------------------------------------------------------------- Here are my answers: 1) After *EXTENSIVE* benchmarking on our 4gl application (medical billing, about 450,000 lines of code in 4gl) we found an avreage of 15 to 20% increase in SQL QUERY time. This is after tuning the On-line engine with buffering and raw devices. We found much beter improvements by performance tuning the SQL statements. This gave us greater increases in speed, (the use of temp tables, better index strat, etc..) than the leap into On-line. Other SQL operations: UPDATE, DELETE improved 10 to 15%. 2) The actual process of migration is straight forward, the configuring and re-configuring required to optimize On-line for your application may not be. If your application queries system tables, for example, you may have to change some of the table refrences, because some system tables in On-line are different than in SE. Some of your maintenance scripts may have to change. (We have a "kill user" [Don't I wish] script that just does a kill -9 on their processes, for SE. This could be more damaging in the On-line environment. 3) TAKE THE ON-LINE CLASS OFFERED BY INFORMIX. It helped our developers consider all they needed (most) before migrating. granholm@cnj.digex.net Medic Computer Systems, Inc. Edison, New Jersey.