Re: ESQL/C library functions - Any change from 5.x to 7.x
Posted in 1997
Topics: Performance & Tuning, Connectivity: ESQL/C, 4GL & Embedded SQL
Actually, Dr. Spitz, we use the relay module (sqlrm) for exactly the purpose you described and we don't seem to be taking a "huge" performance hit. Mind you, I am not saying we couldn't improve performance by ridding ourselves of the need to use sqlrm, but we are not being forced to change. 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? } } Regards, Richard } -- } +--------------------------+------------------------------------------+ } | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | } | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | } | Klinikum Grosshadern | FAX : +49-89-7095-8886 | } | 81366 Munich, Germany | GSM : +49-172-8933578 | } +--------------------------+------------------------------------------+