Re: Is there a way to speed up my import

2013-06-27 Thread Gora Mohanty
On 27 June 2013 14:12, Mysurf Mail wrote: > I just configured with the caching and it works mighty fast now. > Instead of unbelievable amount queries it queris only 4 times. > CPU usage has moved from the db to the solr computer but only for a very > short time. > > Problem : > I dont see the mult

Re: Is there a way to speed up my import

2013-06-27 Thread Mysurf Mail
I just configured with the caching and it works mighty fast now. Instead of unbelievable amount queries it queris only 4 times. CPU usage has moved from the db to the solr computer but only for a very short time. Problem : I dont see the multi value fields (Inner Entities) anymore This is my conf

Re: Is there a way to speed up my import

2013-06-27 Thread Gora Mohanty
On 27 June 2013 12:32, Mysurf Mail wrote: > > I have a relational database model > This is the basics of my data-config.xml > > > > > query="select SKU > FROM [TableB] > INNER JOIN ... > ON ... > INNER JOIN ... > ON ... > WHERE ... AND ...'"> > > > > Now, this takes a lot