[FX.php List] RE: Performance issues with FM's xml interface

[Gjermund Gusland Thorsen]

I use the relationships all over the place,
I do have special layouts for use on web however,
that has been through a special diet.

The diet, the amount of field follow this rule; As few as possible,
but as many as possible. / Less is more.

I believe the performance between FM 6 Unlimited and FM7SA to have a
factor of 20'000, and the difference between FM7SA and FM8SA to be 2-3
times. Now the only potential in speed, compared to OpenSource SQL
servers is about 2%, and that is not worth a change of platform, in
most cases,when you consider the rapid application development that
FileMaker offers.

Gjermund

On 9/29/05, Dennis Crall <dennis-crall at uiowa.edu> wrote:
>
>  Thanks for your note, Tony. However, I'm not convinced the number of fields
> was a key factor. Obviously, if you request less data, a request should
> return more quickly, but that doesn't tell the whole story. We tried
> simplifying our layout in a number of ways (e.g. removing related fields,
> calculations, etc), and we saw no performance improvement until we removed
> the container fields from the layout. As soon as the containers were gone,
> the response time went from over a minute to 1 or 2 seconds.
>
>  That seems like a stiff performance penalty for fields that should only be
> returning a calculated url. We have also noticed slowness while fetching the
> image data as well. This  points to a problem in the XML interface, and
> hopefully it will be addressed in FM8SA.
>
>  Denny
>
>
>
>  On 9/29/05 8:38 AM, "Anthony Talo" <alatalo at chartermi.net> wrote:
>
>
> Dennis,
>  I had the same problem and found that the # of fields in the layout had a
> HUGE effect on the page loading speed. By removing fields not displayed on
> the web we went from a load speed of 1:30 to near-instantaneous!
>
>  Cheers,
>  Tony
>
>
> ---
>  Anthony Talo, Ph.D.
>  Digital Wrangler
>  Macintosh Guru
>  Talo Associates
>  61 West Central
>  Zeeland, MI 49464
>  616-510-0428
>  ________________________________
> _______________________________________________
>  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
>
>
>