Depending on the application, you might be able optimize for searching by doing the indexing yourself when a new CV or keyword is added. ie an index table that correlates CVs-keywords.Only practical if you know the keywords set beforehand though.

Blair

On 4/12/06, Taco Fleur <[EMAIL PROTECTED]> wrote:
thanks, I'll look into it, not sure if I want to go down that road though.
Interesting though to have a look...

 
On 4/12/06, Scott Arbeitman < [EMAIL PROTECTED]> wrote:

I know Verity supports it's own query language (VQL, I believe) which
is made for doing these kinds of things. Not sure if you can
specifically do this thing.

Don't if the version of Verity that comes with CF allows you to hook
into it's VQL ability, but my guess would be it does.

Also coming to mind would be doing queries in memory from a master
query. You could do this in a loop. I think Macromedia suggests 50,000
is a good max for a query in memory.





--
Taco Fleur - http://www.pacificfox.com.au
Web Design, Web development, Graphic Design and Complete Internet Solutions
an industry leader with commercial IT experience since 1994 …




--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

Reply via email to