[SPAM-5.7]- [FX.php List] Limiting fields returned

[Carl Anderson]

Alex:

While we'd love to do that, it'd require a major change in how we operate.
That said, my colleague and I are talking about doing so as a stop-gap
measure; a "whiteboard" layout is our ultimate goal, where we put
non-related fields that we can query easily.

It's too bad I can't limit what we get back.

-- 
Carl Anderson 
Technical Support Analyst
Distance Learning 
Herberger College of the Arts
Arizona State University
http://herbergeronline.asu.edu


> From: Alex Gates <alex at gandrpublishing.com>
> Organization: G&R Publishing Co.
> Reply-To: <alex at gandrpublishing.com>, "FX.php Discussion List"
> <fx.php_list at mail.iviking.org>
> Date: Thu, 15 Nov 2007 12:43:29 -0600
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Subject: Re: [SPAM-5.7]- [FX.php List] Limiting fields returned
> 
> Hi Carl -
> 
> What about putting those 4 fields on a separate layout and querying that
> instead?
> 
> As far as I know, you can't limit what fields are returned.
> 
> 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.
>> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list