Re: Current Informix vs. Oracle Data
>Obnoxio The Clown wrote: > >> Peter Ross wrote: >> >> >In my experience the migration to Oracle of a fairly large application >> >(1,343,045 lines of 4GL code) and all the database has been fast and >> >smooth. I used querix for this migration. >> >> Ah, well I watched someone undertake a very similar migration myself >> (roughly the same size and the same tools) and it was an MCF. There was >> indeed very little code changing required, however, it wasn't really >> quite so smooth. > >Did you just watch or you tried it yourself. I know that querix picked up a >few programming mistakes in our code that was never picked up by informix >compilers (one of them had given us problems from time to time without >knowing why), Quaqlity of code is important, though you may disagree. I would *never* disagree that quality of code is important. :-) The thing is, if you're selling a migration, you can't make assumptions about the quality of the code you're migrating. I've seen similar things with other migration tools, and they all have the same sort of problems. >> It hit the fan when they went into production and found out the >> differences in optimisation strategies and the like. And just because >> Informix-4GL and Querix can compile to C, doesn't mean they run the >> same... :-) > >My experience is different. I'm sure if you asked Querix, they would say that their product ran faster... :-) But it might be an interesting experience to properly benchmark the two products on the same platform. Not that I could be bothered. :) >> Furthermore, what happens if you're used to RDS? You have to learn about >> really rigorous code. That in itself can cause a *lot* of trouble. I'm >> not saying that people who use RDS "loopholes" are right, but that can >> cause a major effort. > >My experience tells me if you have written your code in RDS you will have a >hard job compiling it with informix 4gl/c compiler. They seem to be two >different products. My point exactly. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
I have had very good results with querix both on informix and oracle databases. In my opinion like for like you get better value for your money from querix. Obnoxio The Clown wrote: > >Obnoxio The Clown wrote: > > > >> Peter Ross wrote: > >> > >> >In my experience the migration to Oracle of a fairly large > application > >> >(1,343,045 lines of 4GL code) and all the database has been fast and > >> >smooth. I used querix for this migration. > >> > >> Ah, well I watched someone undertake a very similar migration myself > >> (roughly the same size and the same tools) and it was an MCF. There > was > >> indeed very little code changing required, however, it wasn't really > >> quite so smooth. > > > >Did you just watch or you tried it yourself. I know that querix picked > up a > >few programming mistakes in our code that was never picked up by > informix > >compilers (one of them had given us problems from time to time without > >knowing why), Quaqlity of code is important, though you may disagree. > > I would *never* disagree that quality of code is important. :-) > > The thing is, if you're selling a migration, you can't make assumptions > about the quality of the code you're migrating. I've seen similar things > with other migration tools, and they all have the same sort of problems. > > >> It hit the fan when they went into production and found out the > >> differences in optimisation strategies and the like. And just because > >> Informix-4GL and Querix can compile to C, doesn't mean they run the > >> same... :-) > > > >My experience is different. > > I'm sure if you asked Querix, they would say that their product ran > faster... :-) > > But it might be an interesting experience to properly benchmark the two > products on the same platform. Not that I could be bothered. :) > > >> Furthermore, what happens if you're used to RDS? You have to learn > about > >> really rigorous code. That in itself can cause a *lot* of trouble. > I'm > >> not saying that people who use RDS "loopholes" are right, but that > can > >> cause a major effort. > > > >My experience tells me if you have written your code in RDS you will > have a > >hard job compiling it with informix 4gl/c compiler. They seem to be > two > >different products. > > My point exactly. > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com
Obnoxio The Clown wrote: > >Obnoxio The Clown wrote: > > > >> Peter Ross wrote: > >> > >> >In my experience the migration to Oracle of a fairly large > application > >> >(1,343,045 lines of 4GL code) and all the database has been fast and > >> >smooth. I used querix for this migration. > >> > >> Ah, well I watched someone undertake a very similar migration myself > >> (roughly the same size and the same tools) and it was an MCF. There > was > >> indeed very little code changing required, however, it wasn't really > >> quite so smooth. > > > >Did you just watch or you tried it yourself. I know that querix picked > up a > >few programming mistakes in our code that was never picked up by > informix > >compilers (one of them had given us problems from time to time without > >knowing why), Quaqlity of code is important, though you may disagree. > > I would *never* disagree that quality of code is important. :-) > > The thing is, if you're selling a migration, you can't make assumptions > about the quality of the code you're migrating. I've seen similar things > with other migration tools, and they all have the same sort of problems. > > >> It hit the fan when they went into production and found out the > >> differences in optimisation strategies and the like. And just because > >> Informix-4GL and Querix can compile to C, doesn't mean they run the > >> same... :-) > > > >My experience is different. > > I'm sure if you asked Querix, they would say that their product ran > faster... :-) > > But it might be an interesting experience to properly benchmark the two > products on the same platform. Not that I could be bothered. :) I think you should bother to test things for yourself. It would make your comments much more objective. I can talk of my particular experience, I was really desperate for migrating an application to Oracle. I have had very good results with Querix. I believe you have not had such a direct exposure. This is a serious news group where people turn to, in order to get some help, it is hardly the place to make comments which on subjects you know nothing about. > > > >> Furthermore, what happens if you're used to RDS? You have to learn > about > >> really rigorous code. That in itself can cause a *lot* of trouble. > I'm > >> not saying that people who use RDS "loopholes" are right, but that > can > >> cause a major effort. > > > >My experience tells me if you have written your code in RDS you will > have a > >hard job compiling it with informix 4gl/c compiler. They seem to be > two > >different products. > > My point exactly. > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com