On 29 October 2012 15:36, mroosendaal <mroosend...@yahoo.com> wrote: > Hi, > > It seems to work without the cache option, the downside is it will takes > ages for everything to be indexed and my testset is 20 times smaller than > the productset.
Someone else will have to respond as to how to use CachedSqlEntity in Solr 4.0. I have not tried it out yet. > Indexing just the root item takes 3 minutes (>600K) but every subentity > takes more time which is obvious but i would've hoped it would at least be > faster. [...] This, on the other hand, does not sound right: 3min per record seems way too high. Have you given Solr enough memory? The bottleneck could also be the network or the database. > How can i speed this up, the bottleneck is not the CPU or memory, but simply > the databasetime. What do you mean by the "databasetime". It seems odd that the database would take long to respond to a simple select. Are your tables indexed? Have you checked CPU/RAM on the database server? Regards, Gora
