> I'm currently look for a database for Delphi v1.0 (yes 16-bit) that allows
> access to it's tables using ALL the native Delphi database components.
> Especially TQuery.
> Currently Paradox/Dbase support is far too slow due to not being able to use
> Secondary indexes in your queries, and Interbase is fast becoming a pain when
> you need multi-user support.
> I have see several good replacements out there for Access/Btrieve/FoxPro etc.
> however the are either not SQL complient, or for 32-bit only.
BDE SQL uses secondary indexes, when you query indexed field values, but
becomes slow, if you join tables, because it creates temporary tables
on disk even for small result sets, but it will run on machine with 4 MB
of memory. Rethink, if you can optimize queries (create manually temp
table with keys from one table, then query related table,...), because
joins can be replaced in many cases. (Naturally, depends...)
Why don't you try SQL server. I'm currently working with Watcom SQL
server (Sybase recently) and I'm very satisfied with it. It's ODBC
drivers are probably the best on the market (fast). Random table access
is slower than with Paradox tables, but you can do allmost anything with
queries, triggers and stored procs, and they're very fast.
MS SQL is much slower, but offers great integrability with other MS
tools (Word,Excel,...). Access could be useful too, but only if you have
very small tables (<1000 records).
Well, rethink your database strategy and hope this helps.
Robert Cerny - application designer & developer
Neosys Ltd. Ljubljana