You are viewing a plain text version of this content. The canonical link for it is here.

Posted to solr-user@lucene.apache.org by Hong-Thai Nguyen <Ho...@polyspot.com> on 2010/12/30 11:22:36 UTC

Inner index stock big BLOB or separate in a DB ?

Hi,

With big BLOB objects transcripted in Base64, anyone tried a performance test in query with a huge data (~M documents, ~500Gb) to compare 2 methods:

-          store directly theses BLOB-Base64 objects in Index by String field

-          separate these BLOB in a DB, then a URL index field point to associate record to mapping in result search

 

Could you suggest which one is better?

 

Thanks,

 

Hong-Thai NGUYEN

Re: Inner index stock big BLOB or separate in a DB ?

Posted by "Grijesh.singh" <pi...@gmail.com>.

Second option is better. Storing Big BLOB data in index will increase index
size and it will create performance issues

-----
Grijesh
-- 
View this message in context: http://lucene.472066.n3.nabble.com/Inner-index-stock-big-BLOB-or-separate-in-a-DB-tp2166964p2167129.html
Sent from the Solr - User mailing list archive at Nabble.com.