Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!ames!purdue!gatech!udel!rochester!pt.cs.cmu.edu!sei!dmc
From: dmc@sei.cmu.edu (Dawn Cappelli)
Newsgroups: comp.databases
Subject: Re: New system/need application advice....
Message-ID: <4005@fy.sei.cmu.edu>
Date: 6 Sep 89 15:16:45 GMT
References: <1989Sep3.232158.7277@expert.com>
Reply-To: dmc@sei.cmu.edu (Dawn Cappelli)
Organization: Software Eng. Inst.;Carnegie-Mellon U.; Pittsburgh, PA 15213   _USA_
Lines: 23

In article <1989Sep3.232158.7277@expert.com> dfickes@expert.com (David Fickes) writes:
>
>We are considering a new database system to handle a sales
>application.  Probably have 6-12 tables and the biggest key
>is useability. 

>We currently have all the data running in Ingres 5.X on
>our Suns but find that our response rate is too slow and
>that we have deadlocking problems.  

Your database doesn't sound like it's very complex, and you should be 
able to get the performance you need out of a Sun.  Has anyone in
your organization taken Relational Technology's Advanced Performance 
seminar?  I would highly recommend it if not.  It covers some 
deadlocking issues, as well as many other performance issues.  It's a
really good seminar, but you want to be sure to send someone who 
understands the basic storage structures (btree, isam, hash & heap).

You may still need a consultant, but the seminar is well worth the cost.
-- 
Dawn Cappelli	dmc@sei.cmu.edu   sei!dmc     (412) 268-6170

This is only my opinion, and doesn't necessarily reflect the opinion of the SEI.