Antonio,
I think it is just a matter of forgetting desktop databases and start
thinking in terms of c/s databases. Forget tables and start thinking sets
of records. 5000 records is nothing in the world of c/s. E.g. I work at the
Cancer Registry of Norway and we have registered every single cancer in
Norway since 1953 (well, almost) - in total over 1 million - all this in
one single database. The same database contains some information like the
address of all hospitals in Norway and whatever else is natural to have in
that database. Still, at 1Gb with a simple structure I don't even think it
qualifies to be called a big database in Firebird terms. Sure, we have to
be a bit careful about which queries we send off to the server (i.e. check
the plan before execution), but in general we do not have any performance
problems. Firebird can handle huge volumes if you treat it nice ;o)

Set

At 10:40 30.10.2002 +0100, you wrote:

>Svein,
>yes, I know, that is a possible way, but when customer will installs 10
>services, the tables will be growing too much and performance will be
>early compromised. At this moment, in each installed service, I have two
>table that have more than 5,000 records. Do you agree?
>Antonio