Well, I've done a lot of work with MySQL and content management systems -- and frankly whenever I have to integrate with Solr or do some Lucene work I am amazed at the speed -- even when I index web pages for search -- MySQL pales by comparison when data sets get large (2> million rows)
Thanks, MM. On Tue, Nov 1, 2011 at 12:01 PM, Robert Stewart <bstewart...@gmail.com>wrote: > One other potentially huge consideration is how "updatable" you need > documents to be. Lucene only can replace existing documents, it cannot > modify existing documents directly (so an update is essentially a delete > followed by an insert of a new document with the same primary key). There > are performance considerations here as well (how to do bulk updates > quickly, etc.). > > Bob > > > On Nov 1, 2011, at 11:47 AM, Memory Makers wrote: > > > Greetings guys, > > > > I have been thinking of using Solr as a simple database due to it's > > blinding speed -- actually I've used that approach in some projects with > > decent success. > > > > Any thoughts on that? > > > > Thanks, > > > > MM. > >
