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.
| Author |
Topic |
|
Luke101
Starting Member
30 Posts |
 Posted - 2008-12-26 : 11:30:08
|
| Hello,I debating on which search method to use for my website. I will have fulltext indexing on one column. Just wanted to know -- performance wise what is more efficient if my table will reach over 100,000 rows. May take some time to get there but when I do I don't wanna see any performance lose when my applications database gets huge. I did some searching and some lean towards custom index using LIKE and UNIONs and some lean toward fulltext searches. So which one is more effieciaent and will have the lightest load on my database server.I have thought of using google as my search tool but things may not get indexed immediately. I really don't mind the index lag with google as long as it is worth the time. What do you guys think? |
|
|
Luke101
Starting Member
30 Posts |
Posted - 2009-01-04 : 02:28:14
|
| No one huh |
 |
|
|
|
|
|
Fulltext vs Like vs Google Search