[FX.php List] Best Practice

nicholas fowlie nickfowlie at hotmail.com
Wed Sep 20 18:24:51 MDT 2006


You should particularly try to steer clear of calculation fields on the layout you are accessing FM with, if that possible of course, as they have to be evaluated when you retrieve data from the layout, and thus can add a lot of time to any FIND/ FINALL request.


  ----- Original Message ----- 
  From: Tom Sepper<mailto:tsepper at dctandt.com> 
  To: FX.php Discussion List<mailto:fx.php_list at mail.iviking.org> 
  Sent: Wednesday, September 20, 2006 3:23 PM
  Subject: RE: RE: [FX.php List] Best Practice


  I just spent the time removing unused fields from all of my layouts. I
  must say that the speed is far better!

  Is this documented somewhere and I was just a goof and missed it? 


  ---
  Tom Sepper
  Director of Information Technology
  Director's Choice Tour & Travel

  P 806.762.6354
  F 806.763.7637

  tsepper at dctandt.com<mailto:tsepper at dctandt.com>
  www.directorschoicetourandtravel.com<http://www.directorschoicetourandtravel.com/>

  -----Original Message-----
  From: fx.php_list-bounces at mail.iviking.org<mailto:fx.php_list-bounces at mail.iviking.org>
  [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Gjermund
  Gusland Thorsen
  Sent: Wednesday, September 20, 2006 12:53 PM
  To: FX.php Discussion List
  Subject: Re: RE: [FX.php List] Best Practice

  Affirmative

  On 9/20/06, Alex Gates <alex at gandrpublishing.com<mailto:alex at gandrpublishing.com>> wrote:
  > Yes, I think it does - as a returned query puts everything from the
  > layout in the resulting array.
  >
  > Please correct me if I'm wrong...
  >
  > Alex P. Gates
  >
  > -----Original Message-----
  > From: fx.php_list-bounces at mail.iviking.org<mailto:fx.php_list-bounces at mail.iviking.org>
  > [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Tom Sepper
  > Sent: Wednesday, September 20, 2006 12:46 PM
  > To: FX.php Discussion List
  > Subject: [FX.php List] Best Practice
  >
  > Not to hijack this, but ggt got me thinking.
  >
  > Since any field to be used with FX.php has to be on the layout
  specified
  > in the FX instance, that begs the question..  Does placing all fields
  a
  > table on the layout slow down the FX.php >> WPE/XML >> FM query?
  >
  > ---
  > Tom Sepper
  > Director of Information Technology
  > Director's Choice Tour & Travel
  >
  > P 806.762.6354
  > F 806.763.7637
  >
  > tsepper at dctandt.com<mailto:tsepper at dctandt.com>
  > www.directorschoicetourandtravel.com<http://www.directorschoicetourandtravel.com/>
  >
  > -----Original Message-----
  > From: fx.php_list-bounces at mail.iviking.org<mailto:fx.php_list-bounces at mail.iviking.org>
  > [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Gjermund
  > Gusland Thorsen
  > Sent: Wednesday, September 20, 2006 12:41 PM
  > To: FX.php Discussion List
  > Subject: Re: Re: [FX.php List] Anyone using XSLT anymore?
  >
  > Hmm sounds like your client only needs one field pr layout.
  >
  > See if that improves speed, to me the solution sounds silly...
  >
  > There are template engines like smarty, or you could just make a
  > couple of php/html templates yourself...
  >
  > ggt667
  >
  > On 9/20/06, Bob Patin <bob at patin.com<mailto:bob at patin.com>> wrote:
  > >
  > > I'm using 8.5... but what I'm thinking is that I'll just add a field
  > to the
  > > layout that has the URL to the HTML file... shouldn't add any
  > overhead, I
  > > woudln't think, since all I'm returning from FileMaker is the URL.
  > >
  > > I may still return some of the HTML from the database; these reports
  > are
  > > made up of about 20 chunks of HTML, and when I return the chunks the
  > speed
  > > is just fine. The problem arises when I have to return all 20
  "chunks"
  > in
  > > one long report; I may just output the long report to static HTML
  and
  > leave
  > > the little chunks embedded in the database...
  > >
  > > At any rate, it's great to see a solution. I'd completely overlooked
  > the
  > > possibility of using a hybrid of static HTML and database... I use
  it
  > all
  > > the time for photos and such, but hadn't thought about it in this
  > > context...
  > >
  > > Best,
  > >
  > > Bob Patin
  > > Longterm Solutions
  > > bob at longtermsolutions.com<mailto:bob at longtermsolutions.com>
  > > 615-333-6858
  > > http://www.longtermsolutions.com<http://www.longtermsolutions.com/>
  > >
  > >   CONTACT US VIA INSTANT MESSAGING:
  > >      AIM or iChat: longterm1954
  > >      Yahoo: longterm_solutions
  > >      MSN: tech at longtermsolutions.com<mailto:tech at longtermsolutions.com>
  > >      ICQ: 159333060
  > >
  > >
  > >
  > >
  > > On Sep 20, 2006, at 11:04 AM, DC wrote:
  > > I just remembered that in order for this architectural change to
  work
  > you
  > > must be using a version of the WPE that lets you return the data
  from
  > a
  > > layout that is different from your search layout. otherwise there is
  > no way
  > > to stop the HTML field that you want to search from spewing itself
  > into the
  > > XML result. so, this scheme wouldn't work in FMP6.
  > >
  > > dan
  > >
  > >
  > > _______________________________________________
  > > FX.php_List mailing list
  > > FX.php_List at mail.iviking.org<mailto:FX.php_List at mail.iviking.org>
  > > http://www.iviking.org/mailman/listinfo/fx.php_list<http://www.iviking.org/mailman/listinfo/fx.php_list>
  > >
  > >
  > >
  > _______________________________________________
  > FX.php_List mailing list
  > FX.php_List at mail.iviking.org<mailto:FX.php_List at mail.iviking.org>
  > http://www.iviking.org/mailman/listinfo/fx.php_list<http://www.iviking.org/mailman/listinfo/fx.php_list>
  >
  > _______________________________________________
  > FX.php_List mailing list
  > FX.php_List at mail.iviking.org<mailto:FX.php_List at mail.iviking.org>
  > http://www.iviking.org/mailman/listinfo/fx.php_list<http://www.iviking.org/mailman/listinfo/fx.php_list>
  >
  >
  >
  >
  > _______________________________________________
  > FX.php_List mailing list
  > FX.php_List at mail.iviking.org<mailto:FX.php_List at mail.iviking.org>
  > http://www.iviking.org/mailman/listinfo/fx.php_list<http://www.iviking.org/mailman/listinfo/fx.php_list>
  >
  _______________________________________________
  FX.php_List mailing list
  FX.php_List at mail.iviking.org<mailto:FX.php_List at mail.iviking.org>
  http://www.iviking.org/mailman/listinfo/fx.php_list<http://www.iviking.org/mailman/listinfo/fx.php_list>

  _______________________________________________
  FX.php_List mailing list
  FX.php_List at mail.iviking.org<mailto:FX.php_List at mail.iviking.org>
  http://www.iviking.org/mailman/listinfo/fx.php_list<http://www.iviking.org/mailman/listinfo/fx.php_list>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060920/3932d9aa/attachment-0001.html


More information about the FX.php_List mailing list