[FX.php List] Limiting fields returned

[Carl Anderson]

Joel:

It takes the bulk of that time to return just the records--I stripped out
the calculating bits of PHP just to be sure.  Presently I'm looping only
through the relevant fields.

I've been pleased with the limited testing of FXneoCache we've done.  That
same query above took 3 minutes on first load, 1 second on the second load.
We use file caching right now, which is enough for us (and faster, too, as
I understand it).

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


> From: Joel Shapiro <jsfmp at earthlink.net>
> Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Date: Thu, 15 Nov 2007 11:16:38 -0800
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Subject: Re: [FX.php List] Limiting fields returned
> 
> 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
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list