Thanks for your feedback Stephen. I guess I'll stick with dBase. As you
say it does the job.
Cheers
John Mason
Stephen Barker wrote:
>
> I don't believe you will see any significant difference in performance
> between any of those alternatives (using the BDE), depending of course on
> what you are doing with indexes, filters etc.
>
> As for reliability, I would stick with dbf - I have been using it for 18
> years. It is a very basic format, but unless you need some other features or
> data types it does the job.
>
> For reliability, don't forget the usual 'local share=true' and
> dbisavechanges BDE stuff.
>
> If you really want to improve reliability and performance though, download
> IB6, ditch the BDE by using IBX components.
>
> Steve.
>
> > -----Original Message-----
> > From: Mason, John [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, 27 July 2000 17:00
> > To: Multiple recipients of list Database
> > Subject: Re: [DUG-DB]: Database formats - which is best?
> >
> >
> > No real reason for changing, but I thought that dBase III is probably
> > getting a bit tired, and thought that Access or Paradox may be
> > faster/more stable/more flexible/better for multi-user access.
> >
> > I can't really justify the cost of DBISAM (US$199.00?).
> >
> > Distribution size is not a problem as this program is only used
> > in-house.
> >
> >
> > Stephen Barker wrote:
> > >
> > > John, what are your reasons for wanting to change?
> > >
> > > Personally I use DBISAM (commercial database, non-BDE,
> > supports SQL) for
> > > small applications especially where the distribution also
> > needs to be small.
> > >
> > > For larger databases I would go for Interbase 6 - It's open
> > source now. With
> > > Delphi 5 Pro you can use the new IBX components and avoid the BDE.
> > >
> > > regards,
> > > Steve
> > >
> > > > -----Original Message-----
> > > > From: Mason, John [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, 27 July 2000 14:23
> > > > To: Multiple recipients of list Database
> > > > Subject: [DUG-DB]: Database formats - which is best?
> > > >
> > > >
> > > > I'm in the process of updating a program and would appreciate some
> > > > advice on the relative merits of different database formats.
> > > >
> > > > I have a simple Document Management system (in Delphi 5
> > Pro) that uses
> > > > flat-file databases with a maximum of about 20,000
> > records, used by 60
> > > > people in our office. The databases are currently dBase
> > III format. I
> > > > was considering changing to Access, although I guess the
> > > > other option is
> > > > Paradox.
> > > >
> > > > Could anybody give me some advice on the relative merits of the
> > > > different systems, or point me towards some discussion of
> > the options.
> > > >
> > > > Thanks in advance
> > > >
> > > > John Mason
> > > > Sinclair Knight Merz
> > > > --------------------------------------------------------------
> > > > -------------
> > > > New Zealand Delphi Users group - Database List -
> > > > [EMAIL PROTECTED]
> > > > Website: http://www.delphi.org.nz
> > > >
> > >
> > --------------------------------------------------------------
> > -------------
> > > New Zealand Delphi Users group - Database List -
> > [EMAIL PROTECTED]
> > > Website: http://www.delphi.org.nz
> >
> > --
> > John Mason
> > Sinclair Knight Merz Limited
> > 54 The Terrace, Wellington, New Zealand
> > Phone: +64-4-473 4265, Fax: +64-4-473 3369
> > --
> > NOTICE - This message contains privileged and confidential information
> > intended only for the use of the addressee named above. If you are not
> > the intended recipient of this message you are hereby
> > notified that you
> > must not disseminate, copy, or take any action in reliance on
> > it. If you
> > have received this message in error please notify Sinclair Knight Merz
> > Limited immediately. Any views expressed in this message are those of
> > the individual sender, except where the sender has the authority to
> > issue and specifically states them to be the views of Sinclair Knight
> > Merz.
> > --------------------------------------------------------------
> > -------------
> > New Zealand Delphi Users group - Database List -
> > [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> >
> ---------------------------------------------------------------------------
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
