Re: Comparason between SE and On-Line DSA and/or OWS

In article <64uvlk$rv0$1@cadmium.aware.nl>, "V.K.A. Aarts" <development@casavhv.nl> writes >We are an application software company for a local market using Informix SE >for some years now. Our customers want to upgrade to On-Line (on Unix) and >OWS (on NT) >Like the majority of us, we do not want to re-engineer our 4gl and NewEra >applications much, but we are aware of behavior changes between SE and the >other engines. > >QU: Has anyone made a comparison matrix between the above mentioned engines >(in a readable format) on subjects like: > No, but Don't run Online 5.x it had adjacnet row locking. When you lock a row you also lock the adjacent row. Causes all kinds of locking problems. >4GL code to be changed You must return the correct number of variables from ALL functions. That is the major one. Recompile with c4gl -anyerr to that non-SQL type errors are not ignored (OK so this is a vast simplification but just use -anyerr ok). You cannot close a cursor twice You need to FREE cursors as well as prepared statements. >Performance issues OWS only supports one CPU VP (basically one CPU) With OWS Informix only supports one instance per machine. >Tuning aspects Online is totally differnt - you need to go on an Admin course. >Scalability Online DSA is better than OWS is better than SE. >Multi-Tier solutions > >I went through the www.iiug.org info and Tech.Notes from Informix but they >do not clarify were to watch out for. > >Our customer database sizes are aprox. 1 GB up to 4 GB and are in the OLTP >environment using client/server applications in a Windows 95 environment.. > >Thanks > >e-mail : development@casavhv.nl >homepage (in Dutch, sorry....) casavhv@casavhv.nl > > >Vincent Aarts e-mail : vaarts@club.tip.nl > > > -- David Williams