[FX.php List] [Off] Multiple database files or 1 file w/ multipletables

[Gjermund Gusland Thorsen]

There is a benefit of making a new file for Web Only and just pull
instances from FileMaker solution into that Web Only table's
relatationship graph,

main benefit is tidyness, that file will only contain layouts for web
queries and web laundring scripts.

Remember to make the same account in all files where web is in use,
typically I make the web account without delete permissions and make a
"black spot"-status field to filter out "deleted" records using a
relationship.

ggt

2007/12/14, VanBuskirk, Patricia <pvanbuskirk at otc.fsu.edu>:
> I'm not sure about the performance gain, but it sure helps when it comes
> time to change passwords and rights.
>
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Nick Trenary
> Sent: Friday, December 14, 2007 10:43 AM
> To: FX.php Discussion List
> Subject: [FX.php List] [Off] Multiple database files or 1 file w/
> multipletables
>
> I recently upgraded from FMS5.5 to FMS9.  I have several small databases
>
> (under 50 records per db) that I use on our web site.  Is there any
> performance gain from merging them all to one database with non-related
> tables or keeping them as separate files?
>
> Thanks,
> Nick
>
> --
> --
>
> Nick Trenary
> Computer Information Systems Analyst
> Cedar Rapids Public Library
> Office: 319.398.5145 x267
> Cell: 319.310.7699
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>