> Date: Tue, 23 Jan 2007 16:54:54 +1100 > From: Chris Stebbing <[EMAIL PROTECTED]> > Subject: Database Alternatives > To: Delphi DB List <delphi-db@elists.org> > Message-ID: > <[EMAIL PROTECTED]> > Content-Type: text/plain; charset=us-ascii; format=flowed; > x-avg-checked=avg-ok-2E4765E > > Hi All, > > I've avoided using SQL now for many years as I really > don't want to spend the time to learn that stuff. Flat > files or a simple master-detail are really good enough > for me. > > But... I need an alternative. I've been using Absolute > database but their filtering performance is well behind > the rest. I'm thinking of Access but I seem to be having > trouble using indexes as I get a "current provider does > not support the necessary interface for Index > functionality" error. > > Can anyone advise a suitable alternative? I'm using D2005 > although I do have access to D2006. > > Standard application for me is a flat file table with > 500,000 records around the 100Mb mark. I need to be able > to filter and run analysis on the filtered table. I use > the raw filter strings as this gives me the most > flexibility - perhaps it's just because I'm used to it. > > Cheers, > Chris. >
Chris, I stayed away from SQL for too long for the same reason but was compelled to change. Haven't looked back. Most of the time I use firebird for my own program and Oracle on the bosses time. I couldn't go back to others Mick _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db
