[FX.php List] best way to search a lot of fields on a lot of records

[Gjermund Gusland Thorsen]

I would try to build a solution that uses relationship for user's
account number.

2008/1/26, Dale Bengston <dbengston at preservationstudio.com>:
> Hi Alex,
>
> Another way to go would be to perform queries on user account number +
> each of the other fields, and then combine the returned data arrays
> prior to display. This way, you're only bringing back as many records
> as you'll display. In other circumstances, I often use the approach
> you mentioned.
>
> Dale
>
>
>
> On Jan 25, 2008, at 9:56 PM, Alex Gates wrote:
>
> > Hi everyone -
> >
> > I'm looking for some feedback regarding the best way to search a lot
> > of fields (5 or so - some of them pretty long text fields) on a lot
> > of records (90,000+ and growing) -
> >
> > To complicate things a, I need to make sure I only bring back
> > records from the user's account number.
> >
> > My first instinct would be to:
> >
> > When a search is performed on the website, query FM and return all
> > the records for the account number - then search that array and
> > build an array with rec id and the title field of records that match
> > the query.
> >
> > Would you say this is the best way to do this?
> > I honestly can't think of any other way.
> >
> > Thanks for your help,
> >
> > Alex
> > _______________________________________________
> > 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
>