Posted by Michael Sims on 01/19/05 04:58

Richard Lynch wrote:
> Brian A. Anderson wrote:
[...]
>> I am thinking of incrementally adding the resultant hits into two
>> associative arrays with the link to the data and a calculated
>> relevance value, and sorting this array by these relevences.
[...]
> One Axiom: Keep as much of the scoring/sorting in your SQL as
> possible -- That's what SQL engines are best at.

I suggest the original poster look into some of the full text indexing
capabilities of his SQL server. A lot of these (for PostgreSQL and MySQL
anyway) will automatically return a relevance value and handle sorting based
on that. As you said, that'll be a heck of a lot more efficient and easier
to implement that doing it in PHP.

• Next in thread: Re: [PHP] searching and sorting
• Prev in thread: Re: [PHP] searching and sorting
• Next in forum: How to access remote files with php?
• Prev in forum: Re: [PHP] $_SERVER['HTTP_USER_AGENT'] in html email
• Thread view: searching and sorting

[Reply to this message]