[FX.php List] Best way to sort?

Steve Winter steve at bluecrocodile.co.nz
Thu May 17 14:49:54 MDT 2012


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



More information about the FX.php_List mailing list