Xref: utzoo comp.databases:8010 comp.sys.mac.hypercard:5156
Path: utzoo!utgpu!watserv1!watmath!att!linac!pacific.mps.ohio-state.edu!zaphod.mps.ohio-state.edu!usc!apple!bbn.com!descalan
From: descalan@bbn.com (David Escalante)
Newsgroups: comp.databases,comp.sys.mac.hypercard
Subject: Re: Accessing an Oracle database from the hypercard interface
Message-ID: <61191@bbn.BBN.COM>
Date: 29 Nov 90 18:43:34 GMT
Sender: news@bbn.com
Followup-To: comp.databases
Organization: Bolt Beranek and Newman, Inc.
Lines: 30
References:<1990Nov27.162424.6319@dhw68k.cts.com> <2650@kirk.nmg.bu.oz>

In article <2650@kirk.nmg.bu.oz> cameron@kirk.nmg.bu.oz (Cameron 
Stevenson) writes:
> From article <1990Nov27.162424.6319@dhw68k.cts.com>, by 
mrx@dhw68k.cts.com (Mark Murphy):
> > In article <499@n5pph007.UUCP> you write:
> >>
> >>    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 tried replying to this via email, but it bounced, so I'm posting.... We 
are developing a "mission-critical" application using either Oracle for 
Hypercard/SQL*Net or SequeLink for Hypercard (from techGnosis), and so far 
our performance tests against a VAX 8700 using localtalk and a fairly 
complex Oracle database (thousands of records, dozens of tables) show 
GREAT response times, in the order of 1-2 seconds per query.  This is not 
a Mac or a Hypercard limitation that is causing the problem.  Nor is it a 
fundamental network issue, since we're getting about the same results via 
TCP/IP or Appletalk, localtalk or ethernet.  Rather, it's probably in the 
way you're coding, as suggested by other posters.  If you do a "select ... 
into ... from ... where ...", then "get next rows", it should work just 
fine.  If you are using prototype cards or something, it will be much 
slower.
------------------------
David Escalante
Internet: descalan@bbn.com  Applelink: N0608
UUCP: {backbone}!bbn!descalan