really? I'm using sql server indexing on text fields at the moment and it works great. It's a document management system where I strip the text contents from a pdf store the pdf in an image field and store the text in a text field. Sql server has been able to search any/all parts of the text field with no problems. It's also very fast.
Originally we had this set up in verity. Whilst Verity has some really cool functionality from the start, it seemed hard to expand on it. For instance, we wanted to have a variable amount on keyword fields. Aside from the 2 custom fields in verity we couldn't figure out how to do this. In sql, we just added more columns to the row. Also row security was a lot easier for me to implement. On the downside, I haven't figured out how to get sql server to do suggestions as verity can and verity does seem a lot more polished. On 1/6/06, Mark Fuqua <[EMAIL PROTECTED]> wrote: > Well, I discovered one problem, Memo fields cannot be indexed, so notes > field, if it is to be indexed, is limited to 255 characters. > > Mark > > -----Original Message----- > From: Mark Fuqua [mailto:[EMAIL PROTECTED] > Sent: Friday, January 06, 2006 9:16 AM > To: CF-Talk > Subject: Verity vs. sql indexing > > > I know the answer is verity is better at full text searches, but I am > curious how much better and at what point. I have a notes table with a memo > field. If I have the memo field indexed by the database, how many records > does in need to reach before it starts having a hard time with "contains" > searches? > > The benifet of the database, from my very finite view point, is it gets > indexed everytime a new record is added, and the user interface and code > would be exactly the same as all my other search pages, which just set the > where clause for the select statement. > > thanks, > > Mark > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228701 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
