Re: substituting a db

2007-12-21 Thread alexander lind
On Dec 21, 2007, at 9:56 AM, Ryan McKinley wrote: solr does not do approximations. Faceting with large indexes (500K is not particularly large) just requires RAM for reasonable performance. Give it a try, and see what you think. Excellent, happy to hear that. Give it a try I will, pretty

Re: substituting a db

2007-12-21 Thread Ryan McKinley
I think Solr would handle this better personally, and you'd get full-text search as an added bonus! :) But, of course, it is advisable to give it a try and see. Solr is quite easy to get rolling with, so it'd be well worth a try. The one part I am most worried about is that solr would s

Re: substituting a db

2007-12-21 Thread alexander lind
On Dec 21, 2007, at 8:16 AM, Erik Hatcher wrote: On Dec 21, 2007, at 1:33 AM, alexander lind wrote: I have a pretty big app in the works, and in short it will need to index a lot of items, with with some core attributes, and hundreds of optional attributes for each item. The app then nee

Re: substituting a db

2007-12-21 Thread Erik Hatcher
On Dec 21, 2007, at 1:33 AM, alexander lind wrote: I have a pretty big app in the works, and in short it will need to index a lot of items, with with some core attributes, and hundreds of optional attributes for each item. The app then needs to be able to make queries like 'find all items w