framar studios
 REAL SOLUTIONS FOR REAL BUSINESS
Search Articles:
Keywords:

Index

Home
Contact
Authors

Sections

About...

Explorations in Web Development

Freeware

Portfolio: Frank's Work

Tutorials: Solutions for techs


Login
User Name:
Password:

ElliDavis.com

Apr 14, 2001 By Frank Marion


Frank Marion, Web Application Developer
Email: [email protected]
Web: http://www.framarstudios.com

Frank has over ten years of experience in the field of internet development. His skills range the gamut of web developement fields, and is known for the quality of his work.
Tip
Searching with Verity or SQL?
Searching your database: Which to use? Verity is best at handling large chunks of unstructured text. It automatically handles stemming (love, loved, loves, loving, lover) and is best at handling 'natural language' ('Who loves me?') type queries.

SQL is best of finding precise matches in very structured information (like prices). Verity can, however give you somewhat mushy results. Why not search the return of your verity query with SQL?

The Pro side: Very accurate results with good control over your data. The Con side: You lose relevance ranking, and must resort to using ORDER BY.

[All Tips]