Subject | Re: [firebird-support] Multiple DBMS Access to single GDB files |
---|---|
Author | Elmar Haneke |
Post date | 2003-12-12T07:47:12Z |
Tim Ledgerwood schrieb:
"load balancing" it is required to have multiple disks involved - else
ther will be no performance gain. Therefore for load-balancing purpose
multiple physical copies of the database are maintained.
Usually it would me more performant if all clients do connect directly
to the DBMS-Server on the machine where the data is stored.
handle this situation. Maybe the usage of Peer-Databases as MS-Access
(or SQLite) should be considered here. These DBMS are prepared to work
on an shared file.
Elmar
> Each DBMS engine looks at the same database (in IB/FB terms, the GDB file)What exactly should be the benefit from doing this. When planning
> file over the network.
"load balancing" it is required to have multiple disks involved - else
ther will be no performance gain. Therefore for load-balancing purpose
multiple physical copies of the database are maintained.
Usually it would me more performant if all clients do connect directly
to the DBMS-Server on the machine where the data is stored.
> Is there any sense in doing this? Can one do it with IB/FB? Should one doI would assume that none of the commonly known database-servers can
> this? (IMHO, NO, DEFINITELY NOT!)
handle this situation. Maybe the usage of Peer-Databases as MS-Access
(or SQLite) should be considered here. These DBMS are prepared to work
on an shared file.
Elmar