[FX.php List] Hitting a FM Server with a large search request

[Dale Bengston]

Hi Ed,

The cheap-and-cheesy way is to concatenate all 15 fields into a text  
field (returns between field contents) and run your search against that.

There are a few ways to execute this. I thought of three; they are  
listed in order of most attractive to least attractive (in my opinion):

1. Have FX.php pass data to the discrete fields and do the concat for  
the big blob when you modify a record.
2. Run an FMP script every time a record is modified and concatenate  
the other fields to the big blob.
3. Make the big blob field be an FMP calculation field.

Personally, I try to avoid using FMP where I can accomplish the same  
thing with PHP. That's why I favor option 1.

Hope this helps,
Dale

On Jan 21, 2007, at 11:57 PM, Edward L. Ford wrote:

> Hi everyone,
> Currently, I have a search page with 15 different fields a user can  
> fill out.  I feel like this is a lot just by the sheer number of  
> options presented to first time users.  I'd like to have a one  
> field search box only -- users love simple interfaces -- and this  
> search searches all fields.
>
> My only concern is the load on the FM server by requesting it  
> search for a string in 15 fields (and possibly more than that in  
> the future).  Does anyone have any experience with this issue?  I'd  
> love to hear from your experience.  Also, if anyone has any  
> thoughts on reducing the load, or building in some sort of "smart  
> search" capabilities to help the PHP application, I'd be interested  
> in your thoughts.
>
> Cheers,
> --Ed
>
> ---------------------
> http://www.edwardford.net
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070123/98e1d2eb/attachment-0001.html