StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POUse SOLR on Mysql relational database. Use SOLR for only product table
text
Body
copied!<p>I am a bit confused as to where SOLR usage ends and where it begins.</p> <p>I use php with a relational mysql db for a shopping site where all tables are related to the product table joining the tables as theyre queried. Needless to say its too slow!</p> <p>e.g.</p> <ul> <li>Category table - catid, catname, catdesc </li> <li>Brand table - brandid, brandname, branddesc</li> <li>Product table - productid, productname, productdesc, catid, brandid</li> <li>(I also use ranges for price ranges etc) </li> </ul> <p>I am wondering whether I should use SOLR to index the whole relational schema or whether just to index the product table alone and let my application work as it currently does.</p> <p>If I just switch the product table to use SOLR are there any caveats to this?</p> <p>e.g. in mysql I can do a fulltext search while joining the brand table. This will allow brands to also be searched upon. Is it possible to achieve the same thing just by switching the product table to SOLR? Are there any other caveats I should be looking out for.</p> <p>I also would like to create a new table for "searches". This would allow me to use keywords in a mysql table in the following way:</p> <p>Searches table - searchterm (e.g. lipstick), synonyms (e.g. lipstick, lips etc.)</p> <p>ie. this would allow me to search upon multiple terms at the same time - a good time to use SOLR facets maybe instead of storing searches in mysql?, or should I just use mysql to store the searches and pull the products from SOLR?</p> <p>Any help is gladly appreciated</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload