WebPagetest Forums
Database Query Search Time - Printable Version

+- WebPagetest Forums (https://www.webpagetest.org/forums)
+-- Forum: Web Performance (/forumdisplay.php?fid=3)
+--- Forum: Optimization Discussions (/forumdisplay.php?fid=5)
+--- Thread: Database Query Search Time (/showthread.php?tid=295)

Pages: 1 2 3 4 5 6


RE: Database Query Search Time - green-watch.org - 10-16-2010 12:44 AM

Hey Guys,

Some little quirk I found with SOLR is that if you want to do exact matches such as PRODUCT_SHIPPING_AVAILABLE:"US" a field has to be of type string and not of type text.

<field name="PRODUCT_SHIPPING_AVAILABLE" type="string" indexed="true" stored="true" required="false" />

My product section is taking longer than I anticipated but it is coming along quite nicely. I ended up with a little over 9.7 million products once the csv files were all processed. A lot of businesses on GAN have no CSV file and it would be too tedious to import manually, but I am happy with the products I do have in the database.

More updates to come.

Sincerely,
Travis Walters