Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!iuvax!ux1.cso.uiuc.edu!ux1.cso.uiuc.edu!m.cs.uiuc.edu!ksmith
From: ksmith@m.cs.uiuc.edu
Newsgroups: comp.databases
Subject: query/update ratio?
Message-ID: <3900029@m.cs.uiuc.edu>
Date: 13 Nov 89 16:36:00 GMT
Lines: 17
Nf-ID: #N:m.cs.uiuc.edu:3900029:000:596
Nf-From: m.cs.uiuc.edu!ksmith    Nov 13 10:36:00 1989



I have heard it said that (read-only) queries comprise 80-90% of
the transaction mix in a "standard" (accounting, banking, personnel)
database environment, the rest being various database-modifying updates
(insert, modify, delete).

Can anyone point me to a study which says this?  Or would someone who
has studied this mix in such environments be willing to write me
and let me know what sort of ratio you have observed?  (I'm doing research
on database environments which are not query dominated.)

	Thankyou,
		-Ken Smith
		 ksmith@m.cs.uiuc.edu
		 University of Illinois
		 Urbana-Champaign