Re: Questions concerning BNR3

on 10.9.2008 1:41, rus1807 wrote:

> but when I try to refresh and get the headers for the group I
> pick it is so.....s...l...o...w. Then it usually causes my
> whole computer to crash.

I guess it might be the unfortunate default database settings...

Put this set of commands into a batch file and run it in the BNR 
DB folder. It will set the DB parameters to values which have 
positive impact on performance.

sqlite msgdb.bnr "pragma default_temp_store=memory;"
sqlite msgdb.bnr "pragma default_cache_size=200000;"
sqlite msgdb.bnr "pragma default_synchronous=off;"
sqlite grpdb.bnr "pragma default_temp_store=memory;"
sqlite grpdb.bnr "pragma default_cache_size=100000;"
sqlite grpdb.bnr "pragma default_synchronous=off;"

You can play with the cache_size values, make them smaller if you 
think BNR eats too much memory.

-- 
	Bye, Evzen

------------------------------------

Important Addresses:
Post message: [email protected]
Group owner:  [email protected]
BNR homepage: http://www.bnr2.org/
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/bnr1/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/bnr1/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[email protected] 
    mailto:[email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/