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]

Search Articles:
Keywords:

Login
User Name:

Password: