RE: Out of memory during query

2016-03-28 Thread Roll, Kevin
- From: Chetan Mehrotra [mailto:chetan.mehro...@gmail.com] Sent: Monday, March 28, 2016 2:01 AM To: users@sling.apache.org Subject: Re: Out of memory during query > select * from [nt:base] where uploadToImageManagerFlag = true Logically this query should not consume much memory (no order by a

Re: Out of memory during query

2016-03-28 Thread Chetan Mehrotra
-Original Message- > From: Roll, Kevin [mailto:kevin-r...@idexx.com] > Sent: Friday, March 25, 2016 4:51 PM > To: users@sling.apache.org > Subject: RE: Out of memory during query > > A practical question on #3... I'm trying it and it seems to work well. Let's > say I do

RE: Out of memory during query

2016-03-25 Thread Jason Bailey
e best we could ever get it to run in jackrabbit with a query was 10 minutes. -Original Message- From: Roll, Kevin [mailto:kevin-r...@idexx.com] Sent: Friday, March 25, 2016 4:51 PM To: users@sling.apache.org Subject: RE: Out of memory during query A practical question on #3... I'm

RE: Out of memory during query

2016-03-25 Thread Roll, Kevin
...@sas.com] Sent: Friday, March 25, 2016 1:01 PM To: users@sling.apache.org Subject: RE: Out of memory during query A couple of observations. 3. Queries are generally slow. In the most counter intuitive experience I've ever had. We've discovered it is far faster to manually descend through

RE: Out of memory during query

2016-03-25 Thread Roll, Kevin
Bailey [mailto:jason.bai...@sas.com] Sent: Friday, March 25, 2016 1:01 PM To: users@sling.apache.org Subject: RE: Out of memory during query A couple of observations. 1. The query you created is amazingly broad with the usage of nt:base and no restricitions such as path. If you're going to create

RE: Out of memory during query

2016-03-25 Thread Jason Bailey
- From: Roll, Kevin [mailto:kevin-r...@idexx.com] Sent: Friday, March 25, 2016 12:46 PM To: users@sling.apache.org Subject: RE: Out of memory during query I am still working through the out-of-memory issue. The problem seems to be identical to what I saw in November - a potentially unbounded query

RE: Out of memory during query

2016-03-25 Thread Roll, Kevin
I am still working through the out-of-memory issue. The problem seems to be identical to what I saw in November - a potentially unbounded query that eats up memory. I thought that configuring a resultFetchSize in Jackrabbit had fixed the issue, but apparently not, and I'm not sure that this