Current time: 06-23-2018, 06:43 AM Hello There, Guest! (LoginRegister)

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Query Search Time
10-16-2010, 12:44 AM
Post: #51
RE: Database Query Search Time
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
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Database Query Search Time - pmeenan - 07-04-2010, 12:03 PM
RE: Database Query Search Time - pmeenan - 07-05-2010, 04:35 AM
RE: Database Query Search Time - sajal - 07-05-2010, 05:03 AM
RE: Database Query Search Time - pmeenan - 07-08-2010, 08:47 PM
RE: Database Query Search Time - sajal - 08-13-2010, 10:06 PM
RE: Database Query Search Time - sajal - 08-14-2010, 03:38 AM
RE: Database Query Search Time - sajal - 08-14-2010, 06:50 AM
RE: Database Query Search Time - pmeenan - 08-16-2010, 02:55 AM
RE: Database Query Search Time - sajal - 08-17-2010, 01:14 AM
RE: Database Query Search Time - pmeenan - 08-23-2010, 01:22 AM
RE: Database Query Search Time - pmeenan - 08-23-2010, 08:45 PM
RE: Database Query Search Time - ringman57 - 08-24-2010, 11:52 PM
RE: Database Query Search Time - ringman57 - 08-25-2010, 02:54 AM
RE: Database Query Search Time - green-watch.org - 10-16-2010 12:44 AM

Forum Jump:


User(s) browsing this thread: 2 Guest(s)