I have around 7000 blob records containg word Doc's.(Its increasing ...)
I need a text search on this BLOB feild.
I am considering two options as of now:
1. store all the BLOB into the local File system of the App Server and use file search.i.e create a file object and loop and search.Thus every time i insert a new blob from application i do it on the server FS and in the DB.
2. Write a proc in the DB where i loop and the blobs and search my text.(I dont know how..)
Any Help would Be greatly Appreciated...
Thanks in Advance.
I need a text search on this BLOB feild.
I am considering two options as of now:
1. store all the BLOB into the local File system of the App Server and use file search.i.e create a file object and loop and search.Thus every time i insert a new blob from application i do it on the server FS and in the DB.
2. Write a proc in the DB where i loop and the blobs and search my text.(I dont know how..)
Any Help would Be greatly Appreciated...
Thanks in Advance.