November 5th, 2003, 03:15 PM
re-indexing on BLOB
I hope someone must have encountered this problem and have a workaround solution.
I am storing docs/pdf as BLOB in the database. I use Oracle Intermedia to search for words in these documents. To facilate this, I would have to re-index the BLOB column.
Intially I would upload around 3000 docs indexed to the BLOB. Each subsequent upload (insert) by the user would require re-indexing , taking up time.Is there a work around solution apart from re-indexing after each insert to facilate the search? How could I enable searching prior to upload.
Any advice/best practices is greatly appreciated.Thanks in advance!