<nico-callewaert@...> wrote in message
news:b16qdg+hui3@......

> Hi,
>
> I don't know if this is a good idea, but I want to make a

application

> with a database running local on a computer. I know I better use
> Paradox tables for something like that, but once you're used to

work

> with a RDBMS and use the full power of a DB engine, like triggers

and

> SP's, no one likes to go back to flat file tables. I can connect

to

> the DB, but queries are so very slowly compared to the same Db
> installed on a server. I know Firebird is a Db designed to work
> through TCP/IP, that's why I'm wondering if you can "cheat" the
> computer and make the thing running fast on a local machine ?
>
> Thanks in advance
>
> Nico Callewaert

If you're up to it, I suppose you can modify the source
code to make Firebird function in a non client/server
style. In theory this should allow you to embed a copy
of Firebird in your app (the MPL style license allows you
to do this without requiring you to release the sources
to the rest of your app, just your mods to Firebird) and
be able to use it without having the end-user setup
Firebird separately.

Even using TCP/IP locally apparently introduces some
overhead. Under NT, MySQL can use named pipes instead
of TCP/IP which are supposed to speed things up when
doing local queries. MySQL also has a linkable non C/S
library libmysqld. I'd like to see something similar
become available with Firebird. That would mean I could
use Firebird in lieu of something like DBISAM. Interbase
was always touted as being an embedded DBMS, but the fact
that it is a separate install belies this claim. It
was always a C/S database, not an embedded one.