Re: Solr performing Calculations vs. Pulling data Values Directly From DB Question

2018-10-18 Thread Walter Underwood
> | www.informationclearinghouseinc.com > > Need Help? Click here to request IT Support. > > > -Original Message- > From: Walter Underwood [mailto:wun...@wunderwood.org] > Sent: Wednesday, October 17, 2018 11:35 AM > To: solr-user@lucene.apache.org > Sub

RE: Solr performing Calculations vs. Pulling data Values Directly From DB Question

2018-10-18 Thread Joseph Costello - F&D Reports
ject: Re: Solr performing Calculations vs. Pulling data Values Directly >From DB Question Instead of putting things in a database, I would put an HTTP cache, like Varnish, in front of Solr. Then you get the best of both worlds. Fast fetches for things that have already been calculated and resu

RE: Solr performing Calculations vs. Pulling data Values Directly From DB Question

2018-10-17 Thread Joseph Costello - F&D Reports
st IT Support. -Original Message- From: Shawn Heisey [mailto:apa...@elyograg.org] Sent: Wednesday, October 17, 2018 11:30 AM To: solr-user@lucene.apache.org Subject: Re: Solr performing Calculations vs. Pulling data Values Directly From DB Question On 10/17/2018 9:19 AM, Joseph Costello

Re: Solr performing Calculations vs. Pulling data Values Directly From DB Question

2018-10-17 Thread Walter Underwood
Instead of putting things in a database, I would put an HTTP cache, like Varnish, in front of Solr. Then you get the best of both worlds. Fast fetches for things that have already been calculated and results for any query that shows up. The client does not need special code to get the manually

Re: Solr performing Calculations vs. Pulling data Values Directly From DB Question

2018-10-17 Thread Shawn Heisey
On 10/17/2018 9:19 AM, Joseph Costello - F&D Reports wrote: Any feedback from the group on the question below. The question was will solr performing distance calculations (10,000++) on the fly, perform faster than SQL query simply pulling pre-calculated distance values directly from the datab

RE: Solr performing Calculations vs. Pulling data Values Directly From DB Question

2018-10-17 Thread Joseph Costello - F&D Reports
g' Subject: Solr performing Calculations vs. Pulling data Values Directly From DB Question My question is regarding using Solr for doing fast geospatial calculations against multiple locations. For example we have a product that takes 2 to 10 companies at a time (i.e. McDonalds 1

Solr performing Calculations vs. Pulling data Values Directly From DB Question

2018-10-15 Thread Joseph Costello - F&D Reports
My question is regarding using Solr for doing fast geospatial calculations against multiple locations. For example we have a product that takes 2 to 10 companies at a time (i.e. McDonalds 14,000 Subway 20,000, Duncan Donuts 5000), and identifies and maps any store overlap based on a range betw