Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!apple!amdahl!rtech!davek From: davek@rtech.rtech.com (Dave Kellogg) Newsgroups: comp.databases Subject: Re: Do you like your UNIX RDBMS? Message-ID: <2949@rtech.rtech.com> Date: 1 Jun 89 15:18:15 GMT References: <9703@dasys1.UUCP> <3378@fp.sei.cmu.edu> <2907@osiris.UUCP> <427@fdmetd.uucp> Reply-To: davek@rtech.UUCP (Dave Kellogg) Organization: Relational Technology Inc, Alameda CA Lines: 27 >In article [...] emuleomo@yes.rutgers.edu (Emuleomo) writes: > ..... > I am getting frustrated with the performance of embedded SQL. > I think you've got the tail wagging the dog here. If you are frustrated with the performance of your SQL-based DBMS, it's the SQL engine that you should be worried about. Generally, if things are slow it's not because Embedded SQL is running slowly, it's because your queries to the database are running slowly. Therefore, causing yourself a lot of pain and using a call-level interface (with say 2-4 times the amount of code) and sending the same SQL statements to the engine won't change a thing. If the problem is the server's performance in processing SQL queries, it doesn't matter HOW the SQL got to the server. You can code it in Embedded SQL, call-level 3GL, or interactively, and it shouldn't change the performance of the queries one bit. That is, I'd argue that you are really "frustrated with the performance of your database engine" not with "embedded SQL," and changing your interface to the server won't help. (This is all on the assumption that Informix has a reasonable ESQL implementation, which I assume, but don't know for sure) David Kellogg Relational Technology (INGRES) New York City