I think I have found the problem. When I select a certain column, it takes
a long time. Think that is where I have to start looking. ;-)
Thanks. I will try union also.
At 08:56 AM 2/27/2004, you wrote:
>-----Original Message-----
>From: Jacob [mailto:[EMAIL PROTECTED]
>Sent: Friday, February 27, 2004 11:44 AM
>To: CF-Talk
>Subject: RE: Improving stored procedure
>
> > So I want to search title and subtitle for "music." If I search only
>title
> > or only subtitle by itself, it pulls the information quickly. If I use
>the
> > two together, it take a loooooooooooong time.
>
>
>Try a union then? Instead of combining the two text searches in an or, try
>something like:
>
>
>SELECT *
>FROM DVD
>WHERE contains(title, 'music')
>UNION
>SELECT *
>FROM DVD
>WHERE contains(subtitle, 'music');
>
>----------
>[
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Re: Improving stored procedure Nick de Voil
- RE: Improving stored procedure Philip Arnold
- RE: Improving stored procedure Jacob
- RE: Improving stored procedure Philip Arnold
- RE: Improving stored procedure Plunkett, Matt
- Re: Improving stored procedure Nick de Voil
- RE: Improving stored procedure Plunkett, Matt
- Jacob