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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-22 : 08:45:09
|
Adrian writes "I am doing a search for substrings in a Name field.
The code looks like:
SearchArray=split(trim(request("search")))
SELECT * FROM Files WHERE Name LIKE '%"SearchArray(0)"%' AND Name LIKE '%"SearchArray(1)"%' AND Name LIKE '%"SearchArray(2)"%'
This is causing a complete table look up in the Files table. When stress testing my application I can only get about 6 concurrent connection to the page. If I am look for a value using WHERE Name='"&string&"' I can easily get about 80 concurrent connections to my page. Is there a way to make substring matching more efficient. Any help on this problem would be greatly apprectiated." |
|
|
|
|
|
Substring indexing