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

substituting a db

2007-12-20 Thread alexander lind
Hi List 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 with attributes attribute_1=yes, attribute_