aburt@isis.UUCP (Andrew Burt) (08/01/89)
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."