Re: gateway Magic - Oracle

mvdaal_at_arisco.nl wrote in message <35b88ef8.24181987_at_news.atriserv.nl>...
>We're having a Magic application (not with embedded SQL) on a client
>with a gateway for an Oracle database. This database is on an Unix
>server somewhere else.
>We're using SQL*Net.
>The performance is very bad and we think this has to do with the
>gateway Magic - Oracle.
>Is there anyone who has experience with this?
>
>mvdaal_at_arisco.nl

If you are talking Magic (formerly MagicPC from MSE) development tool, it gives best performance with its 'bread and butter' database (BTrieve ISAM).

I have only used Magic with Btrieve but went to a class in which they discussed the various database engines that Magic works with and the various gateways.

With Oracle/Sybase/etc. (or any relational SQL database), going through the record suffix takes way more time than should be required since it goes through one by one... As we know, Oracle, etc. behaves well when you fetch a bunch of records at the same time (a la the 'Cursor').