[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