Subject | 2 databases and SuperServer |
---|---|
Author | svanderclock |
Post date | 2008-12-30T11:02:08Z |
hello,
I have an idea to better use all the processor : "split" my database in
2 databases (for exemple one database with the user sessions,
statistiques, etc.. so very write and read intensive but easy SQL
query, and the other database with all the CRM, read intensive and
heavy SQL but only few write on it) !
my question, if i have 2 differents databases, is firebird super server
will use 2 processors (or create 2 threads) for each database ?
I guess the answer will be no ! so is it possible to run 2 instances of
firebird superserver on the same server ? one for each database ?! if
yes how to do so ?
thanks by advance for you help
stéphane
I have an idea to better use all the processor : "split" my database in
2 databases (for exemple one database with the user sessions,
statistiques, etc.. so very write and read intensive but easy SQL
query, and the other database with all the CRM, read intensive and
heavy SQL but only few write on it) !
my question, if i have 2 differents databases, is firebird super server
will use 2 processors (or create 2 threads) for each database ?
I guess the answer will be no ! so is it possible to run 2 instances of
firebird superserver on the same server ? one for each database ?! if
yes how to do so ?
thanks by advance for you help
stéphane