Cheers,
Jan
_______________________________________________ Ferret-talk mailing list [email protected] http://rubyforge.org/mailman/listinfo/ferret-talk
As a sidenote I'd like to mention that ferret tends to be faster as mysql on columns / fields with short texts either if there are many, many datasets. I for example made this experience on a mysql database with millions of rows of short varchars in it's columns. Mysql, even while optimized by an experienced DBA, with all necessary indices set and queries that EXPLAINed to be optimized had quite some problems in handling lots of queries, while ferret made a damn good job on querying the same data. I've had a sense of achievement because of ferret / lucene with this. That said it is quite uncommon to have millions of categories so Jens suggestion seems to be very reasonable on this point.
Cheers,
Jan
Cheers,
Jan
- Re: [Ferret-talk] adding new items to index breaks searches ... Jens Kraemer
- Re: [Ferret-talk] adding new items to index breaks sear... Jan Prill
- Re: [Ferret-talk] adding new items to index breaks sear... Clare
- Re: [Ferret-talk] adding new items to index breaks sear... David Balmain
