Subject Re: [ib-support] Cross-db query
Author Antonio Parrotta
Svein,
sorry for the question, but I never programming in terms of c/s databases, so can you tell me how it works and what is the main difference?
thanks for your time!
Antonio
Svein Erling Tysvaer <svein.erling.tysvaer@...> wrote: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)








---------------------------------
MIo Yahoo! : personalizza Yahoo! come piace a te

[Non-text portions of this message have been removed]