Re: Use dataimporthandler cache with stored procedures

2015-11-25 Thread Mikhail Khludnev
Hello Jean-Philippe, You either call it 300 times with the different param value, without cache or load all rows once and cache them SQL examples in the doc explain this clear, I suppose. On Wed, Nov 25, 2015 at 2:27 PM, Jean-Philippe Quéméner < jeanphilippe.queme...@gmail.com> wrote: > Hi,

Use dataimporthandler cache with stored procedures

2015-11-25 Thread Jean-Philippe Quéméner
Hi, I'm trying to import my data from an sql database using the dataimporthandler. For some nested entity I want to use the cache to cache the result of my stored procedure. My config looks like this > > > > >cacheLookup="product.brand_id" cacheImpl="SortedMap