[FX.php List] multiple copies of database to balance the load?
Alex Gates
alex at gandrpublishing.com
Tue Aug 19 18:13:47 MDT 2008
Hi everyone -
Would there be any improvement the speed of a web app if there was more
than one copy of the database and users were assigned one specific
database at registration?
You could have one database manage user credentials and then they'd be
assigned either Database1, Database2, Database3, etc. for the other part
of the app.
We are seeing a lot of activity and as a result, overall performance is
declining.
People are creating lots of records and the queries and records returned
are really getting up there.
Is the slowdown more so determined by the hardware and filemaker server
as a whole, or would distributing the load across multiple databases
help the situation?
Any thoughts / advice would be appreciated.
Alex
More information about the FX.php_List
mailing list