From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.3 required=5.0 tests=BAYES_00,INVALID_MSGID autolearn=no autolearn_force=no version=3.4.4 X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 103376,a1868a27625c21e7 X-Google-Attributes: gid103376,public From: Al Christians Subject: Re: Looking for keyed file package Date: 1999/09/22 Message-ID: <37E9A967.50DA6680@easystreet.com>#1/1 X-Deja-AN: 528511412 Content-Transfer-Encoding: 7bit References: <37E817C6.80ED41E0@easystreet.com> <7saii8$5bl$1@nnrp1.deja.com> <37E8F0C1.A49C3E2D@easystreet.com> <7sc6i4$cep$1@nnrp1.deja.com> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii X-Trace: typ12.nn.bcandid.com 938059956 206.103.58.89 (Thu, 23 Sep 1999 00:12:36 EDT) Organization: Trillium Resources Corporation MIME-Version: 1.0 NNTP-Posting-Date: Thu, 23 Sep 1999 00:12:36 EDT Newsgroups: comp.lang.ada Date: 1999-09-22T00:00:00+00:00 List-Id: Robert Dewar wrote: > > > Well that's a non-technical objection, and a curious one, > since there are as likely to be free software databases > around as free software indexed file systems (indeed I > know one of the former, none of the latter). > I'm not aware of any 'free software database' that is down to my level of sophistication. What such animal can you recommend for use with GNAT Ada 3.11p under NT? I just fear out of pure ignorance that many of the things that are available in database systems but unneeded in this application -- locking, transactions, multi-user capabilities, joins, set-at-a-time processing, triggers, you-name-it -- carry a pretty heavy cost in performance and general bulk of the application, ie number of things that can go wrong. What I got working today -- a direct_io file with a couple of indexes built in memory each time the application runs -- works fine and appears to be able to create a few thousand records per second and then read and update over 1000 per second. It's also amusing to me that after my data is refined into its final form, I will create an Ascii text file of it to pass to the next application. Using direct_io with a record padded with a crlf, the step of creating the Ascii version of the file is null, there's nothing to do. This random access Ascii via direct_io matches Btrieve in speed, and I can view and patch my database with edlin. Al