On Fri, 22 Aug 1997 14:13:46 -0400, "Joe" <joe@colsys.com> wrote:
> We have a client using Informix SE 4.0 on a SCO Unix system. They want to
>access the database with ODBC, so they upgraded SE 4.0 to 7.12, which
>includes Informix-Net.
>
>The problem is that their Unix application was written using the 4.0 tools
>and hence needs to use the Relay Module (sqlrm) to run. They are
>complaining that the application is now much slower, probably because of the
>relay module.
This is an aside but I would certainly look at page level locking as a
potential culprit here. I dont think the relay module is that much
slower though Ive never used it on a 4.X database
>
>My idea is this: On the Unix system, continue to use the SE 4.0 engine to
>access the database, but still run the 7.12 sqlexecd so ODBC can be used to
>access the database. This will avoid the relay module. However, it means
>that both the 4.0 engine and the 7.12 engine will be accessing the same
>database.
>
>We have not tried this yet, but could it cause problems (such as...)?
>
>
>
>
>
>
>
Mike South
Producer/Director
"Mike South's Southern Belles"
"Mike South's Travels"
Winner 1997 AVN Best Amateur Video
Winner 1996 Rocky Mountain Oyster Readers Poll Best Pro-Am Series