Re: From INFORMIX 5 to 7 - where will the performance go?
------------6F1626CC195F3 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii > If we add the INFORMIX V7.0 only, where will the performance go? > What we have to do, for the same performance under 7.1 as under 5.0. > I can not belive, that we have to install 7.1 only, for the same > performance. > > Is it necessary to add new hardware? Please help me with your suggestions. > For details see the table below. version 7.x is an order of magnitude more involved than version 5.x. it is a shame that you have to go to 7.x, even though you might not need it. there are a lot of variables involved in getting 7.x up and tuned correctly. many times 7.x will run slower than 5.x, until some major tuning is done, and sometimes it still runs slower, depending on the application. there are way too many variables to go into in a single mail message to tell you what to do. i would recommend taking informix's training courses, at least one of the Upgrade or DBA cousre, and then the tuning course. this isn't so much a plug for informix as it is to tell you that there is a lot there, and you need to find all this out from somewhere, and they are obviously the best source. good luck! ------------6F1626CC195F3 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii <HTML><BODY> <DT><BR> > If we add the INFORMIX V7.0 only, where will the performance go?<BR> > What we have to do, for the same performance under 7.1 as under 5.0.<BR> > I can not belive, that we have to install 7.1 only, for the same<BR> > performance.<BR> > <BR> > Is it necessary to add new hardware? Please help me with your suggestions.<BR> > For details see the table below.<BR> <BR> version 7.x is an order of magnitude more involved than version 5.x. it is a shame that you have to go to </DT> <DT>7.x, even though you might not need it. there are a lot of variables involved in getting 7.x up and tuned </DT> <DT>correctly. many times 7.x will run slower than 5.x, until some major tuning is done, and sometimes it </DT> <DT>still runs slower, depending on the application.</DT> <DT> </DT> <DT>there are way too many variables to go into in a single mail message to tell you what to do. i would </DT> <DT>recommend taking informix's training courses, at least one of the Upgrade or DBA cousre, and then </DT> <DT>the tuning course. this isn't so much a plug for informix as it is to tell you that there is a lot there, and you</DT> <DT>need to find all this out from somewhere, and they are obviously the best source.</DT> <DT> </DT> <DT>good luck!</DT> <DT> </DT> </BODY> </HTML> ------------6F1626CC195F3--