Re: ESQL/C library functions - Any change from 5.x to 7.x

Richard Spitz wrote: > > Art S. Kagel wrote: > > BTW with the Remote Module (sqlrm) you can > > continue to run your 5.0x compiled executables while taking the time to > > recode the source to take better advantage of new features. Performance > > is at least as good as native 5.0x access and bugs in early versions of > > sqlrm were fixed in all versions 7.13 and later. > > You are probably referring to the "relay module" that translates between > the different methods of database access of versions < 6.0 and >= 6.0. > I've never heard of such a thing as a "remote module". > > The general consensus of both the manuals and this group has been that > the relay module gives you a big performance hit and should only be used > as a last measure if you absolutely cannot convert your frontend apps > to a version concurrent with the backend. So I am very surprised about > your statement that performance via the sqlrm is "at least as good". Could > you please explain? Of course, relay module, that's what happens when I try to reply to news postings, UNIX/Internet email, Bloomberg email, answer my phone and get work done all at the same time. Anyway, I have never found the relay module to be a bottle neck compared to 5.0x native access at all. Absolutely a native 7.xx executable will be much faster than a 5.0x executable accessing the 7.xx engine. In general I agree that all code should be converted and I do not think that my statements contradicted that position. However, I recommend rewriting & recompiling any 5.0x source which does not need new features and rewriting those that can take advantage of 7.xx features. However, this can mean delaying the upgrade to 7.xx until the mods are completed and tested and time spent debugging the recompiled 5.0x source for those modules which are not being updated anyway can better be spent recoding the others. So I bring up the 5.0x executable with the relay module while the port is proceding so that the database can be up in 7.xx immediately and the new code can follow later. Art S. Kagel