Searching ntext field

[avesta]

Hi,

I have a SQL Server Database of medical articles with 20 fileds including 2 ntext fields which hold abstract of articles. On of these fields is in english and the other one is in arabic (unicode).

When I run a SELECT query for all fields the It takes too long. If I exclude the 2 ntext fields the query will be much faster (but still far slower compared to when my database was MS Access).

Any help would be appreciated.

[Rawhide]

Is the amount of data stored in the fields enough to warrant using ntext or text fields? If not, you should use varchar and nvarchar!!!

[nosepicker]

Also, you might want to decide if you really need to store the entire medical article in the database. It might be easier for you to store the articles on a hard disk location and then just store the paths of those locations in the database.

[avesta]

1. Unfortunately the data is big enough to be put in ntext field.
2. Actually the fulltext articles are pdf files on hard disk and users download them through their speciefic url which is stored in database. The data in the ntext fields is just "abstract" of articles.

[Rawhide]

Take a look at full-text indexing and see if that would be helpful.

Can you an example search query?