[FX.php List] Record Count after the fact

[Dale Bengston]

Jonathan,

Most of the resource hit/lag is pulling the data out of FMP. I'd  
proceed with the second loop approach. PHP is very fast, especially  
if it's just working internally and not writing anything back to the  
page. Your first pass through the found set will be all PHP.

Dale

On Feb 15, 2007, at 10:53 AM, Jonathan Schwartz wrote:

> I could do that.  However, that would then add a second for loop:  
> one to reduce the data set and write the results to an array and  
> one to write the array for display...in addition to the FMP query.  
> (Hey guys....do you believe that this kind of talk is coming from  
> me...former beginner. ;-)   ).
>
> Seems that this is particularly resource intensive,  No?
>
> Jonathan
>
>
>
> At 11:25 AM -0500 2/15/07, Andy Gaunt wrote:
>> Jonathan,
>>
>> Rather than do a new page, can you do your for loop outside the  
>> HTML first
>> (writing everything to a new variable) then echoing this to your  
>> page once
>> completed?. If so then you could increment a counter variable when  
>> the
>> record matches your criteria ( $counter++; ) and then echo this  
>> out before
>> you echo out your content from the loop.
>>
>> Andy Gaunt
>> Office: 321.206.3658
>> Mobile: 407.810.4722
>> andy at fmpug.com
>> http://www.fmpug.com
>
> -- 
>
> Jonathan Schwartz
> FileMaker 8 Certified  Developer
> Associate Member, FileMaker Solutions Alliance
> Schwartz & Company
> jonathan at eschwartz.com
> http://www.eschwartz.com
> http://www.exit445.com
> 415-381-1852
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list