HP3000-L Archives

March 2001, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Mark Boyd <[log in to unmask]>
Reply To:
Mark Boyd <[log in to unmask]>
Date:
Wed, 7 Mar 2001 15:52:40 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (81 lines)
"it is simpler to use than Image"

A BIGGER crock of Crapola(tm), I haven't heard since my wedding vows.
NOTHING is easier to use than Image.

"the cost/performance "curve" seems to be favoring SQL more and more"

A bigger crock of Crapola(tm), I haven't heard since someone said "SQL was
simpler to use than Image". The only performance curve I've seen with SPL is
downward.  I'm currently babysitting an SQL app that is averaging 3
transactions per second with a maximum speed of 194 transactions per second.
These are inserts, updates and deletes that are transferred from our hp.
Our pimply-faced gurus downstairs have upgraded the server, rebuilt the
server, reinstalled the software, upgraded the software and can't get any
more speed out of it.


* Crapola is a registered trademark of Microsoft Inc.

-----Original Message-----
From: Richard Gambrell [mailto:[log in to unmask]]
Sent: Wednesday, March 07, 2001 3:28 PM
To: [log in to unmask]
Subject: Re: [HP3000-L] Expensive RDBM Systems (Oracle)

"James B. Byrne" wrote:
>
> On 7 Mar 2001, at 15:41, [log in to unmask] wrote:
>
> > This has actually been a 25-year-long running argument. Personally,
> > I'm on both sides of the argument at the same time and could argue the
> > merits on either side with equal conviction.
> >
>
>  It is the same with me.  But recently I have begun to lean more and
> more to the data management side.
>

This is a fruit to vegetables type of comparison.  At the core, we
need a strong file system supported by the operating system,
then a transaction management journalizing system,
then a database system,
then a data management/dictionary system, etc.
MPE has the first 3, but the data management layer is weak.

However, we also have a world that knows SQL, maybe not well, but
nonetheless it is simpler to use than Image.  With cheaper hardware
and more expensive programmers, the cost/performance "curve"
seems to be favoring SQL more and more.   Poor SQL coding can
bring a system to it's knees, but so can poor Image coding or
design.

Note that Oracle offers a number of data management features
on top of the database, but you pay a *lot* for these features.

Note that things like stored procedures and triggers are
proprietary (pl/sql), just like Image calls.
SQL is not proprietary.

Richard

> Regards,
> Jim
> ---   *** e-mail is not a secure channel ***
> James B. Byrne                Harte & Lyne Limited
> vox: +1 905 561 1241          9 Brockley Drive
> fax: +1 905 561 0757          Hamilton, Ontario
> mailto:[log in to unmask]  Canada L8E 3C3

--
Richard L Gambrell, Director of Computing Systems and Networks
Information Technology Division
University of Tennessee at Chattanooga
103 Hunter Hall, Department Code 4454
615 McCallie Ave., Chattanooga, TN 37403-2598
voice mail/cell phone: 423-432-5122
private e-mail: [log in to unmask]
UTC fax: 423-755-4150
UTC phone: 423-755-4551
UTC email: [log in to unmask]

ATOM RSS1 RSS2