[SPAM-5.7]- [FX.php List] Limiting fields returned
Carl Anderson
Carl.Anderson at asu.edu
Thu Nov 15 13:36:15 MST 2007
Dan:
Thanks for posting that. Sadly, the PHP is perhaps 1% or less of the
overall processing time--the rest is all the data pull.
In any case, I'll look into the array_sum() function.
--
Carl Anderson
Technical Support Analyst
Distance Learning
Herberger College of the Arts
Arizona State University
http://herbergeronline.asu.edu
> From: DC <dan.cynosure at dbmscan.com>
> Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Date: Thu, 15 Nov 2007 13:52:50 -0500
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Subject: Re: [SPAM-5.7]- [FX.php List] Limiting fields returned
>
> BTW, your averaging "loop" as described sounds inefficient.
> have you heard of the function array_sum()?
>
> // this code is a sketch, you have to check for zero count
> // or risk a PHP error
> $avg = array_sum($array) / count($array);
>
> there is usually always a better way to do things in PHP. it's a
> learning process.
>
> also, take any unstored calculated fields off the layout if you can or
> make them stored - if they are unstored or sums or any kind of summary
> your performance will suffer greatly.
>
> dan
>
> Carl Anderson had written:
>> 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.
>>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
More information about the FX.php_List
mailing list