Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!ncar!ico!nbires!isis!aburt From: aburt@isis.UUCP (Andrew Burt) Newsgroups: comp.databases Subject: Suggestions wanted for good sized db Message-ID: <2571@isis.UUCP> Date: 1 Aug 89 05:15:06 GMT Reply-To: aburt@isis.UUCP (Andrew Burt) Organization: Math/CS, University of Denver Lines: 25 I've been out of touch with db products for the past few years -- any help is appreciated (if anyone has decent summaries of recent discussions they could e-mail that'd be great too). The application I was thinking about has 10-15 Gb of data growing by about 10k/day; few deletions. (All these figures are ballpark, but probably in the right order of magnitude). Split into a dozen or so separate databases, with the largest one about 25% of the whole. About a dozen keys each. Say between 1 and 5 transactions per second. Some obnoxious contraints on the format of the input data (probably batched), but could be handled by regular expressions a la "egrep". Say 100 concurrent users. Unix platform preferable. (Anything else you want to know, just ask.) So, anyone out there with some recommendations on software and/or hardware that would work well under these conditions? Pointers to good articles you've seen? I'm particlulary interested in hard facts (like "don't buy product X because it gags with dbs > 1 Gb" or benchmarks) and first hand impressions. I will, of course, summarize the replies -- so hit me with the best you've got. -- Andrew Burt uunet!isis!aburt or aburt@du.edu "Now go away or I shall taunt you a second time."