Xref: utzoo comp.databases:7971 comp.sys.mac.hypercard:5112
Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!zaphod.mps.ohio-state.edu!usc!elroy.jpl.nasa.gov!zardoz.cpd.com!dhw68k!mrx
From: mrx@dhw68k.cts.com (Mark Murphy)
Newsgroups: comp.databases,comp.sys.mac.hypercard
Subject: Re: Accessing an Oracle database from the hypercard interface
Message-ID: <1990Nov27.162424.6319@dhw68k.cts.com>
Date: 27 Nov 90 16:24:24 GMT
References: <499@n5pph007.UUCP> <46800@apple.Apple.COM>
Organization: Wolfskill & Dowling residence; Anaheim, CA (USA)
Lines: 36

In article <499@n5pph007.UUCP> you write:
>
>    Is this problem inherent in using the Mac's bit-mapped interface?
>
>    Has anyone else seen/worked through this problem?
>
>    Since we are mainly concerned with using a Mac interface (not 
>       necessarily Hypercard), are there any other packages out 
>       there that someone has experience with that can give the 
>       Mac 'look and feel' but without the 25 sec time delay?  I 
>       realize that Oracle is supposed to come out with a Mac-based
>       version of SQL*Menu and SQL*Forms, but we need to be able to
>       display more than 80 columns.
>
>Any advice would be greatly appreciated.
>

   I have not worked with Oracle connected with SQL*Net before... I have only
worked with the single-user stand alone version for the Mac.  Yet it seems to
me that there should be no 25 sec time delay.  I have not seen any such delay
in the demos I have seen at trade shows, seminars, etc.
   Are you designing your own HyperCard stack to access your data, or are you
using the query stacks that come with Oracle?  If so, those are really slow in
displaying the data after the query.  The reason for this is that HyperCard
must create a new card, create any fields needed, then put the information into
each field.  It is a very slow process.
   The fastest way to retrieve data from Oracle is to use the SELECT INTO
clause.  Then use GET NEXT ROW... or for even faster access GET NEXT xxx ROWS.
   If you are already directing the query results into local variables and have
this time delay, I think it is time to call Oracle Tech Support.  Make sure you
get someone who is familar with the Mac... there are so few of them around!



-- 
mark				mrx@dhw68k.cts.com