[FX.php List] FINDALL failure

Gjermund Gusland Thorsen ggt667 at gmail.com
Mon Feb 25 00:29:58 MST 2008


I have done findall on tables with 450000+ results, it's a bit slow,
but with 4 fields it's OK...

If I make one of the fields on the layout a calculation field it times out...

ggt

2008/2/25, Dale Bengston <dbengston at preservationstudio.com>:
> Hi Bob,
>
>  How many records are potentially retrieved by this findall?
>
>
>  Dale
>
>
>  On Feb 24, 2008, at 5:44 PM, Bob Patin wrote:
>
>  > Can anyone tell me why this has suddenly ceased to work?
>  >
>  > //RETRIEVE THE DEALER TOTALS
>  > $dealer=new FX($serverIP,$webCompanionPort);
>  > $dealer->SetDBData('xx.fp7','users','all');
>  > $dealer->SetDBPassword('xxx','xxx');
>  > $dealer->AddSortParam('company','ascend');
>  > $dealerResult=$dealer->FMFindAll();
>  > echo "ERROR: ".$dealerResult['errorCode'];
>  >
>  > My browser never stops; I even put this into a test page, with just
>  > this code and the FX includes above it...
>  >
>  > Same problem. Might I be needing a server restart? Other sites on
>  > the same server are working normally.
>  >
>  > Thanks,
>  >
>  > Bob Patin
>  > Longterm Solutions
>  > bob at longtermsolutions.com
>  > 615-333-6858
>  > http://www.longtermsolutions.com
>  > Member of FileMaker Business Alliance and FileMaker TechNet
>  >
>  >  CONTACT US VIA INSTANT MESSAGING:
>  >     AIM or iChat: longterm1954
>  >     Yahoo: longterm_solutions
>  >     MSN: tech at longtermsolutions.com
>  >     ICQ: 159333060
>  >
>  > --------------------------
>  > Contact us for FileMaker hosting and programming for all versions of
>  > FileMaker
>  > PHP • CDML • Full email services • Free DNS hosting • Colocation •
>  > Consulting
>  >
>  > _______________________________________________
>  > 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
>


More information about the FX.php_List mailing list