ABN.AFZA-GA%usc-isid@sri-unix.UUCP (12/08/83)
My organization is in need of a DBMS to be used on an Apple running under CP/M. We originally intended to buy dBase II because it seemed too meet all our needs. However, on closer examination, it fell short in one area - max number of fields per record. dBase II only allows a max of 32 fields per record and we need 48. Our other requirements include: a. 6000 records per data base file. b. 1000 characters per record. c. 250 characters per field. All of these requirements refer to max capability needed. We also want it to be able to perform sorts and searches of the data base in a timely manner (under five minutes). If anyone has experience with a DBMS meeting these specs, please reply to me directly. I will summarize to the net if there is enough interest. Thanks in advance. Alan E. Pires Systems Officer, Corps G1 ABN.AFZA-GA@USC-ISID
ron%brl-vgr@sri-unix.UUCP (12/08/83)
From: Ron Natalie <ron@brl-vgr> What are you using for disk drives to accomodate these 6 Megabyte databases? -Ron
ABN.ISCAMS%usc-isid@sri-unix.UUCP (12/09/83)
Ron (et al) I queried 1LT Pires about that momentous database (and the hardware he planned to run it on). Turns out the specs he discussed (6000 records, 1000 characters per record, 250 chars per field, 48 fields) were MAX, way out, absolute extremes for each specification, and not all together! In other words, nope, he won't have one huge DB with 600 records, each having 1000 chars per record, 48 fields, 25 chars per field! But he MIGHT have 6000 records with much smaller sizes, or a couple of hundred records with 48 fields, or 3 fields with 250 chars per field. And available DBMS's won't handle those extremes (at least not to our knowledge). That's why the query. By the way, he and I are discussing "pre-processing" to reduce record length or numbers of fields or other DBMS-imposed constraints to trim the filed data down to a swallowable size (in the event an appropriate DBMS cannot be found for under megabuck range). (We DO think of the taxpayer's money, after all!) Regards, and thanks for the query to keep us on our toes! David Kirschbaum SGM, USA Corps Automation Mgt Office HQ XVIII Abn Corps, Ft Bragg
SHahn@SUMEX-AIM.ARPA (12/15/83)
From: Sam Hahn <SHahn@SUMEX-AIM.ARPA> Try MicroRIM from that company in Seattle. They advertise fairly widely. -- shahn@sumex -------