RE: Re: MsgDB.bnr

Other folks recommend the following:
 
sqlite msgdb.bnr "pragma default_temp_store=memory;" 
sqlite msgdb.bnr "pragma default_cache_size=35000;" 
sqlite msgdb.bnr "pragma default_synchronous=on;" 
 
sqlite grpdb.bnr "pragma default_temp_store=memory;" 
sqlite grpdb.bnr "pragma default_cache_size=35000;" 
sqlite grpdb.bnr "pragma default_synchronous=on;" 
 
Which is better ?
 
Thx,
Bob
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of
margin_short
Sent: Saturday, June 30, 2007 4:18 AM
To: [email protected]
Subject: [BNR] Re: MsgDB.bnr



--- In bnr1@yahoogroups. <mailto:bnr1%40yahoogroups.com> com, "Tony"
<anthonyhc50@...> wrote:
>
> I know this has been asked but I just can't seem to understand it. 
> Using BNR3 but like BNR2 better. Anyway, the database MsgDB.bnr 
> is 2 GIG's, and like to reduce the size, and have it remember what 
> articles were downloaded. I tried the vacuum, and I guess it needs 
> sqlite.exe ver 2 and all I can find is version 3. I get all kinds of 
> errors when I run the batch file. 
> 
> Deleting the database is no help because it reverts back to the same 
> size when I refresh the groups again. The same articles are being 
> included in the refresh.
> 
> Using XP Pro SP2.
> 
> Thanks,
>

Using BNR3 and liking BNR3 better.
I have 7 servers and 21 groups.
(mp3, vcd, svcd, divx, cbt to name a few. The best and most
complete is set for normal (headers and articles). The other 6 are
set for articles only all with 1 connection each. 
All are XHDR with "Don't check for
new/expired articles within range" checked in the advanced tab.

Try this: Limit the number of articles downloaded to
100 in the HEADER SERVER's properties then close BNR3 and delete the 
database. 
This will get you caught up very quickly. Then
you can remove this limit for subsequent header downloads.
Expire headers every 1 day. Use only 1 thread on 1 server for header 
download. 
Works for me fine this way. 
If the DB starts to slow down then repeat. I have
2 instances of BNR3 running together with different groups. While
I'm opening one group I'm checking the headers in the other so
there's no waiting. Awesome program.

Be sure to run the .BAT with the following while BNR3 is closed:

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

The Reaper ROCKS! 



 


[Non-text portions of this message have been removed]



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/