Timeout on sql statement
Wonder if you could point me in the right direction on a problem that I am having.
I am using asp/sql server.
Have a column 'article' which contains several paragraphs of text.
I then have a select statement which uses 'like' to find a snippet of text within that article.
eg.
Select * From articles where article like '%some phrase%'
The problem that I am having is that it is timing out.
I can't do an index on article as the size is too large.
I am calling it from my asp page using a stored procedure.
Any suggestions to make the query faster in order to avoid the timeout?
I am using asp/sql server.
Have a column 'article' which contains several paragraphs of text.
I then have a select statement which uses 'like' to find a snippet of text within that article.
eg.
Select * From articles where article like '%some phrase%'
The problem that I am having is that it is timing out.
I can't do an index on article as the size is too large.
I am calling it from my asp page using a stored procedure.
Any suggestions to make the query faster in order to avoid the timeout?