Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!aramis.rutgers.edu!paul.rutgers.edu!yes.rutgers.edu!emuleomo From: emuleomo@yes.rutgers.edu (Emuleomo) Newsgroups: comp.databases Subject: Re: Do you like your UNIX RDBMS? Message-ID: Date: 30 May 89 22:32:25 GMT References: <9703@dasys1.UUCP> <3378@fp.sei.cmu.edu> <2907@osiris.UUCP> <427@fdmetd.uucp> Organization: Rutgers Univ., New Brunswick, N.J. Lines: 38 Path: paul.rutgers.edu!aramis.rutgers.edu!rutgers!cs.utexas.edu!uunet!mcvax!ndosl!fdmetd!steinar From: steinar@fdmetd.uucp (Steinar Overbeck Cook) Newsgroups: comp.databases Subject: Re: Do you like your UNIX RDBMS? Summary: What's wrong with embedded SQL ? Message-ID: <427@fdmetd.uucp> Date: 30 May 89 07:33:56 GMT References: <9703@dasys1.UUCP> <3378@fp.sei.cmu.edu> <2907@osiris.UUCP> Organization: Fellesdata a.s, Oslo, Norway Lines: 17 In article Steinar Overbeck Cook, writes: > What is wrong with the use of embedded SQL ?. With the use of embedded > SQL your 'C' programs are much more portable than with the use of some > proprietary C-interface. Personally I use Pro*C with our Oracle > database. The precompiler from Oracle is lousy, but I like embedding > SQL in my C-programs. > The problem with Embedded SQL is that is super lousy for browsing thru' a database. Suppose you issue a query and there are 1000 matching records. Are you aware that ALL the current ESQL implementations require that you WAIT FOR THE 1000 RECORDS TO BE FOUND EVEN BEFORE YOU CAN VIEW THE 1ST ONE? Thus your client will be FORCED to wait for up to 5 minutes before he/she gets a response from a simple query! This certainly is NOT PROGRESS. Remember that in _LOWLY_, pseudo-relational Dbase III you can access the 1st record of a matching set super-quickly by using filters and the other records by doing a SKIP. Also this can be done similarly in Informix 3.3. (I think this goes to show that we need 2 simultaneous database models. Relational and Network!) Also, another sore point with a DBMS like ORACLE is that you can't access a PREVIOUS record. ie. you can't browse backwards. THIS SUCKS!! Again, in lowly Dbase, all you have to do is SKIP -1. *** DO YOU NOW SEE WHAT IS WRONG WITH EMBEDDED SQL!!! *** --- Emuleomo O.O. (Disgusted with Embedded SQL!!)