[FX.php List] Limiting fields returned

[Joel Shapiro]

Hi Carl

As others have said, limiting the fields on the layout would be  
preferable.

  2.5 - 5 mins does seem excessive.  How long does it take just to  
return the 600 records?  Are you looping through ALL fields in the  
returned results, or just the four relevant fields?  Maybe you can  
post your code.

Also:  FXneoCache:
Have you been happy with this?  Are other people using it?  When it  
first came out some people reported problems with it.

-Joel


On Nov 15, 2007, at 10:39 AM, Carl Anderson wrote:

> Good day, list:
>
> Is there any way, whatsoever, of limiting which fields are returned  
> from an
> FX.php query?
>
> The reason I ask is that we have a table/layout that has a bunch of  
> related
> fields, and calculations, and all sorts of nonsense...but it  
> happens to be
> the only place that certain data lie.
>
> Right now, I'm trying to calculate an average on four numeric  
> fields that
> are in every record (they're exam scores), so what I'm doing is  
> pulling in
> every record, then looping through that result set, and on each  
> record I
> loop through to see if the fields have data--if so, I add the score  
> to a
> temp array, increment a counter, and so on.
>
> On a result set of roughly 600, it's taking between 2.5 and 5  
> minutes (I
> suspect it's dependent upon what else is going on, on the server).
> Thankfully I'm using FXneoCache to deal with subsequent loads, but the
> initial one is killing me.
>
> Thus the crux of the question: Is there any way to limit what I get  
> back
> from FileMaker, to only the four (or so) fields that contain the  
> scores?
> I'm guessing that would seriously cut down on the processing time.
>
> Thanks for any tips.
>
> -- 
> Carl Anderson
> Technical Support Analyst
> Distance Learning
> Herberger College of the Arts
> Arizona State University
> http://herbergeronline.asu.edu
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list