[FX.php List] fx.php website speed issues

Thu Oct 9 10:03:16 MDT 2008

Just keep the FMSA in your own business,
and use networksolutions or someone else for the web hosting...

ggt

2008/10/9 Hank Shrier <hank at atlasinnovation.com>:
> Have you considered putting the database on another server or server
> configuration.  For a small amount of money you can have the file hosted for
> a month. My guess is you have already burned up more than $60.00 in time.
>
> BTW I don't work for or own a hosting company.  It just seems that this is a
> way to find out whee your problem lies. Is it a problem with the code or
> with the hardware.
>
> Of course that's just my opinion, I could be wrong.
>
> Hank Shrier
> +1 408-252-5418                 Office
> +1 408-387-2111                 Cell
> +1 408-521-1801                  Fax
> hank at atlasinnovation.com
>
>
> THIS COMMUNICATION IS LEGALLY PRIVILEGED AND CONFIDENTIAL
> This e-mail, and any attachments hereto, is intended only for use by the
> addressee(s) named herein.   If you are, or are not, the intended recipient
> of this e-mail, you are hereby notified that any dissemination, distribution
> or copying of this e-mail, and any attachments hereto, without written
> permission, is strictly prohibited. If you have received this email in
> error, please immediately notify me and permanently delete the original and
> any copy of any e-mail and any printout thereof.
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dennis Dalziel
> Sent: Thursday, October 09, 2008 5:42 PM
> To: 'FX.php Discussion List'
> Subject: RE: [FX.php List] fx.php website speed issues
>
> Troy,
>
>        That was one thing that I tried. I removed all external data source
> references from this database to try and speed things up.
>
> Thanks!
>
> Dennis Dalziel
> Production Manager
> G & R Publishing Co.
> 507 Industrial Street
> Waverly, IA 50677
> 319-352-5391
>
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Troy Meyers
> Sent: Thursday, October 09, 2008 10:28 AM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] fx.php website speed issues
>
> Dennis,
>
> Another big impact on speed, possibly the worst, is if there are outdated
> file references.
>
> If the database files were developed on another machine, or are FM files
> that have been around for a while, the file references from the old
> situations may be stored. In my case this cause extreme speed problems when
> I first switched.
>
> Because my files have been around for years, migrating upward from FileMaker
> 2 (before it was even called Pro) the files have secretly collected a long
> list of file paths in computers that I no longer even have. Starting with
> FMS 7 or 8, certainly 9, instead of the files being opened once when the web
> server starts, the files needed have to be located and opened each time a
> query is made. If your list of file paths that a database has relations to
> contains a long list of outmoded, non-valid paths, each of the bad path
> attempts has to time-out before the next candidate is tried. This is VERY
> time consuming, and it happens for each page access that has any related
> files tied in.
>
> So, if your files are at all a "legacy", check this out:
>
> Assuming you are using FileMaker Pro 9, open a file that you use on the web
> that has relationships with other files, and go to the File > Manage >
> External Data Sources... item.
>
> This will bring up a list of file references for your relationships and
> other external things like script references.
>
> Select one of the file references and hit Edit. You'll see a list of file
> paths that will be checked in order to get the related file. Unless the
> first entry is valid and the simplest and most direct, you'll be getting
> delays while the listed paths are tried and failed. Assuming all the files
> are together on the same server, the simples file path should be something
> like:
>
> file:Subscribers.fp7
>
> Before I cleaned out my file references, I might have a whole chain of bad
> paths that FileMaker had kept track of through the years, like:
>
> file:/StarMax HD/Applications/FileMaker Pro 4.0 Folder/Web/flasking/Flasking
> Databases/Subscribers
> file:/Performa/Applications/FileMaker Pro 6.0 Folder/Web/flasking/Flasking
> Databases/Subscribers
> file:Subscribers
>
> In that case, the two nonexistent machines were hunted for on the network,
> before the good reference was tried, resulting in long, long, delays, like
> 30 seconds to a minute, each time a page was loaded.
>
> Check this out in ALL your files, and all your file references.
>
> -Troy
> _______________________________________________
> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>