Re: Questions concerning BNR3

Evzen Polenka said

>> 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 have posted my .bat files to this group soo many times (a search will
show them all), its nice to see others doing so, BUT you HAVE to tune the
cache sizes to your computer IMO the ones in the above post are far too
big, I use 75000 and 45000 on an old AMD 2600 XP. BUT its best to test,
there are also a few lines missing from that .bat file.

sqlite msgdb.bnr "pragma default_temp_store=memory;"
sqlite msgdb.bnr "pragma default_cache_size=75000;"
sqlite msgdb.bnr "pragma default_synchronous=on;"

sqlite grpdb.bnr "pragma default_temp_store=memory;"
sqlite grpdb.bnr "pragma default_cache_size=45000;"
sqlite grpdb.bnr "pragma default_synchronous=on;"

sqlite msgdb.bnr "pragma integrity_check;"
sqlite grpdb.bnr "pragma integrity_check;"

pause

contig *.*

pause


I have posted other .bat files that vacuum and defrag while BNR is shut,
as all of the files must be run while BNR is shut, I also use
synchronous=on so you never loose anything if there is a crash, I have run
side by side tests and there is no slow down, but I think others are not
doing database integrity checks, and also about teh use of contig to
defrag the files.

L_N

-- 
CBS promote the Clash,
            ain't for revolution ...it’s just for cash.
                              --CRASS--



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

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/