You'll want to full text index the TEXT column that you want to search. Rather than using LIKE searches, use the CONTAINS keyword. You'll find that CONTAINS executed against a full text-indexed collumn executes much faster.
~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 4:41 PM To: CF-Talk Subject: Re: memo search in SQL 2000 sql server has no memo datatypes. i guess you mean TEXT? have you added full text indexing service to your sql server? do that 1st. - next add a TIMESTAMP datatype column to your email table. - create text catalog for that db. in EM click on your db, then on "full-text catalogs", create one - in EM right click on your table, click on "define full text indexing"..select the columns that will participate in the full text catalog. you NEED a unique column index (PK) for full text indexing to work (engine won't be able to tell one row from an other otherwise). - go back to full text catalog for that db & start a full population (initially must do). - next chose the type of population you want, either schedule a partial one or use the "new" stuff in sql 2k (don't have 2k at home). the reason we added a TIMESTAMP column is to help the engine determine which rows have been updated, inserted, deleted. install BoL on your development box. worth the effort... > The good news is that I've added some more control to the archives. The bad news is that full text searches are not in yet. If anyone has some advice on setting up SQL 2000 to search a memo field, I'd appreciate it. > Basically, the body of a message is stored as a memo and I want to search it without sending the processor to hell and eating up all the ram. How do I index it? How do I use it best? > I can look it all up but I'm being lazy. :) > Actually, I want to get this done right and the best way to do that is to learn from others experiences. > > Michael Dinowitz > Master of the House of Fusion > http://www.houseoffusion.com > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
