[FX.php List] multiple copies of database to balance the load?

[Gjermund Gusland Thorsen]

I would expect there would be higher performance boost if you separate
web and FileMaker services, or also separate the WPE from the two of
them.

ggt

2008/8/20 Alex Gates <alex at gandrpublishing.com>:
> 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
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>