Xref: utzoo comp.databases:7919 comp.sys.mac.hypercard:5076
Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!elroy.jpl.nasa.gov!sdd.hp.com!uakari.primate.wisc.edu!uflorida!gatech!mcnc!rti!n5pph007!tpg
From: tpg@n5pph007.UUCP (Peter Graham)
Newsgroups: comp.databases,comp.sys.mac.hypercard
Subject: Accessing an Oracle database from the hypercard interface
Message-ID: <499@n5pph007.UUCP>
Date: 20 Nov 90 21:42:34 GMT
Reply-To: tpg@n5pph007.UUCP (T Peter Graham)
Organization: Northern Telecom,  Research Triangle Park,  North Carolina
Lines: 29

We are beginning work on a large Oracle-based system that we want to front-end
on the Mac using Hypercard.  The databases itself will be running on an HP 
unix machine, with the access from the Macs being through SQL*Net.  The
problem is that we are seeing a 20-28 second delay on EVERY database access.
The bottleneck doesn't seem to be on the HP end...the data is being 
sent to the Mac with little to no delay.  There then seems to be some kind of 
hangup in Hypercard.  This delay occurs regardless of the type of access or the 
amount of information returned.  I have several questions:

    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.


-------------------------------------------------------------------------
reply to: ...!mcnc!rti!n5pph007!tpg
NTI may care what I say, but I'm not 
saying it for them...these opinions 
and statements are mine entirely