RE: caceh implemetation?

2015-07-27 Thread cbuxbaum
-node+s472066n421911...@n3.nabble.com] Sent: Friday, July 24, 2015 4:00 PM To: Carl Buxbaum cbuxb...@tradestonesoftware.com Subject: Re: caceh implemetation? On Fri, Jul 24, 2015 at 1:06 AM, Shawn Heisey [hidden email]/user/SendEmail.jtp?type=nodenode=4219114i=0 wrote: On 7/23/2015 10:55 AM

Re: caceh implemetation?

2015-07-24 Thread Mikhail Khludnev
On Fri, Jul 24, 2015 at 1:06 AM, Shawn Heisey apa...@elyograg.org wrote: On 7/23/2015 10:55 AM, cbuxbaum wrote: Say we have 100 party records. Then the child SQL will be run 100 times (once for each party record). Isn't there a way to just run the child SQL on all of the party

Re: caceh implemetation?

2015-07-23 Thread Shawn Heisey
On 7/23/2015 10:55 AM, cbuxbaum wrote: Say we have 100 party records. Then the child SQL will be run 100 times (once for each party record). Isn't there a way to just run the child SQL on all of the party records at once with a join, using a GROUP BY and ORDER BY on the PARTY_ID?

caceh implemetation?

2015-07-23 Thread cbuxbaum
-3857 In the last comment by James Dyer. Here is a distilled, simplified version of our config: Any suggestion how to use cacheImpl here? Thanks! Carl -- View this message in context: http://lucene.472066.n3.nabble.com/caceh-implemetation-tp4218825.html Sent from the Solr - User mailing

Re: caceh implemetation?

2015-07-23 Thread Mikhail Khludnev
Hello, I briefly described the similar problems at http://blog.griddynamics.com/2015/07/how-to-import-structured-data-into-solr.html Let me know if you have further questions On Thu, Jul 23, 2015 at 7:55 PM, cbuxbaum cbuxb...@tradestonesoftware.com wrote: That's OK, I have determined that

Re: caceh implemetation?

2015-07-23 Thread Erick Erickson
, simplified version of our config: Any suggestion how to use cacheImpl here? Thanks! Carl -- View this message in context: http://lucene.472066.n3.nabble.com/caceh-implemetation-tp4218825.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: caceh implemetation?

2015-07-23 Thread cbuxbaum
That's OK, I have determined that caching is not relevant to our use case. However, I have a question about the full import queries that we are using: Here is the SQL from the top level entity: query=SELECT DISTINCT 'LEAP_PARTY' AS DOCUMENT_TYPE, VPARTY.OWNER AS