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 |
|
shenimr
Starting Member
3 Posts |
 Posted - 2007-05-16 : 06:53:47
|
| Querying large text fields resulting in timeout error --------------------------------------------------------------------------------Hello:I have designed a CV database with complete CV stored in a TEXT field. There is a keyword search which queries the TEXT field also. The query conditions are defined in T-SQL submitted through an ASP page. There is about 20,000 records now. Now while querying the database for keyword search I am receiving time out errors. Is there any solution other than Index server to rectify this situation. How can I speed up the query execution time. Please advise.Rgdspooja |
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2007-05-16 : 07:29:08
|
quote:
Originally posted by shenimr
Querying large text fields resulting in timeout error --------------------------------------------------------------------------------Hello:I have designed a CV database with complete CV stored in a TEXT field. There is a keyword search which queries the TEXT field also. The query conditions are defined in T-SQL submitted through an ASP page. There is about 20,000 records now. Now while querying the database for keyword search I am receiving time out errors. Is there any solution other than Index server to rectify this situation. How can I speed up the query execution time. Please advise.Rgdspooja
Why r u storing whole CV into TEXT field? You can design DB in such a way so that CV information can be stored partly. And even u can search on any field of CV.Thanks,MaheshMahesh |
 |
|
|
shenimr
Starting Member
3 Posts |
Posted - 2007-05-16 : 09:51:33
|
| Hello Mahesh,Thanks for the reply. The situation at the time of design was such that the CV had to be stored in the database. Now it is very late to fix the design. Do you have any solution in mind keeping the CVs in the database itself. Please let me know. Rgds pooja |
|
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2007-05-16 : 11:21:35
|
On which platform ur developing the app In such case, what you have to do is, to get the value in Business Logic and then search the specific text into that value. i.e. with the help of functions like INSTR etc. May b i m wrong, but i think, this is the last solution for this,Hopes u ll find another solution which fits for ur situation.best luck,Mahesh |
|
|
|
|
|
|
Querying large text fields results in timeout erro