Yes, bundle Db PM with embedded database was the best for me. I ended up using H2, although the default repository configuration (Derby) is probably good enough.
Rakesh On 10 Feb 2010, at 10:22, Luiz Fernando Teston wrote: > Rajesh, > > So, it appears that using database bundle is the best option for my current > scenario, right? > > Thanks for the feedback! > > > Teston > > On Wed, Feb 10, 2010 at 2:07 PM, Rakesh Vidyadharan <[email protected]>wrote: > >> If you are going to do a lot of writes, the filesystem option may turn out >> to be terribly slow. That was my experience on OS X importing around 40000 >> nodes. >> >> Rajesh >> >> >> On Feb 10, 2010, at 9:53 AM, Luiz Fernando Teston < >> [email protected]> wrote: >> >> Guo, >>> >>> Just curious that is there any performance difference between query >>> >>>> languages: xpath, sql, JCR-SQL2, JCR-JQOM? >>>> >>>> I don't know. I'm using only xpath >>>> >>> >>> >>> The default repository configuration is already very optimized: embed >>>> derby + file store. You cannot get better performance by using remote >>>> db such as mysql. >>>> >>>> I'm trying it with postgresql, but gonna test also with file system to >>> see >>> if it improves the performance or not. >>> >>> Write to disk is much expensive than read in general, so it's >>> >>>> expected. Repository is best for content system, assume most action >>>> are read operation, hope your stress test reflect the read/write >>>> radio. You could aggressively improve read performance by add a cache >>>> layer in your application if applicable. >>>> >>>> >>> We cache information a lot when possible. But this stress test I'm running >>> will be a massive import. So it has lots of writes and also some queries >>> to >>> avoid duplicate data. It's a very uncommon scenario. >>> >>> Thanks for the feedback! >>> >>> >>> Teston >>> >>> >>> >>>> -Guo >>>> >>>> Rakesh Vidyadharan President & CEO Sans Pareil Technologies, Inc. http://sptci.com/ | 100 W. Chestnut, Suite 1305 | Chicago, IL 60610-3296 USA | | Ph: +1 (312) 212 3933 | Mobile: +1 (312) 315-1596 (US), +91 949 611 0873 (IN) | Fax: +1 (312) 276-4410 | E-mail: [email protected]
