Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Snitz Forum Search Stored Proc

Author  Topic 

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2003-10-08 : 13:07:12

Has anybody done this? I am using the basic snitz forum database design, but the search is running too slow so I have disabled it.

Has anybody written a quick, efficient stored proc for this? Seems like a huge task.

Any input appreciated

Thanks alot
mike123

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-10-08 : 18:56:56
Hey Mike

Do you have the option to use full text indexing on your database ?
You should be able to build a pretty quick search out of that.



Damian
Go to Top of Page

aiken
Aged Yak Warrior

525 Posts

Posted - 2003-10-09 : 01:14:08
I have not converted search to use a SP, however I have full-text enabled our search. However, it's a snitz 3.3 codebase, and pretty decently modified for integration into our app.

I'd be happy to share the code if it sounds like it would be useful.

Cheers
-b
Go to Top of Page
   

- Advertisement -