[FX.php List] Best way to sort?

[Steve Winter]

Hi Denis

My thoughts...

Is the field which you want to sort by indexed (or indexible) in FM...? If so, add a sort parameter to your FX query.

If not, get the results back in 'whatever' order from FM and sort with PHP...

That said, the only way to know for sure is to generate a large record set and try both ways...

Let us know what you find...

Cheers
Steve

Sent from the iPhone of Steve Winter
Matatiro Solutions
steve at matatirosolutions.co.uk
+44 777 852 4776

On 17 May 2012, at 21:29, Denis Somar <dsomar at gmail.com> wrote:

> Any best advice on the optimal way to sort.
> 
> I'm not doing anything wild other than sorting in descending order by creation date (and I have this field ), but wanted to know if there's an optimal way to do it.  There can be between 1-(infinity and beyond) most likely 100 results sorted.
> 
> Many thanks,
> Denis
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list