john llewsrac | 1 Jun 09:12 2004
Picon

Re: BNr3.03 seems to spend more time storing headers than it does downloading them

Thanks a lot to Str8 for talking about the way you use
BNR3. Now that I have had my real first taste of
success it is awsome. 

Thanks Dave for filling in the gaps for me. 

This is the real way that I would like to use BNR3.
Just download enough headers to get what I want. Hmmm!
I really like the concept and the idea.   

John

--- john llewsrac <llewsrac <at> yahoo.co.nz> wrote:

---------------------------------
Thanks a lot. Yes that is what I needed. Now I
understand how it works.

John

--- Dave Warren <dave.warren <at> devilsplayground.net>
wrote:

---------------------------------
john llewsrac wrote:

> Smile - I missed something in the translation.
>
>I got to where I put the wildcard in the field and
>exit out.
(Continue reading)

paul warner | 1 Jun 10:32 2004
Picon

BNR3 What causes this ??

Hi there.

Firstly I feel that the database in BNR3 is allot more robust than the 
database used in BNR2.

Several time I have found that BNR causes my PC to slow down and eventually 
freeze.

The symptoms seem to be when the database gets to about the 500Meg 
mark.  The server treads say "waiting for DBlock" and "Cleaning up 
database"  The only out of this when the PC has frozen is to power off and 
start again. When BNR is run up again the treads do the same thing.  If I 
catch it early enough I can "slay" BNR and restart but the problem comes back.

When I restore a backup of the previous nites database it then runs OK .  I 
am currently downloading again with last nites database.

It lasted 15 minutes then froze again.  I disabled  download on all the 
groups and  am downloading each one with  am manual refresh.

(15 minutes later) That worked fine.  Up until the weekend I was only using 
BNR3 for about 5 news groups but  on Sunday I opened it up to all 25 and 
that is when my problem started.  My be in it's infancy and the database 
starts to climb in size there are problems of handling lots of news groups 
on demand.

The version I am running is BNR3 1.0.123 which I think is the 
latest.  Systems is P4. 2.4G, win2K SP4, 512Meg ram.

Thanx In adavance
(Continue reading)

str8 | 1 Jun 14:11 2004
Picon

Re: BNR3 What causes this ??

> Several time I have found that BNR causes my PC to slow down and
eventually
> freeze.

It may be hogging the system and not doing anything you consider useful
(expiring headers), but I've never really seen BNR3 "freeze" here. But then,
I use monitoring software so I can see all the reads/writes it is doing, and
also how much CPU and RAM it is using.

> The symptoms seem to be when the database gets to about the 500Meg
> mark.  The server treads say "waiting for DBlock" and "Cleaning up
> database"

I don't think you're using the latest version. Please upgrade.

>  The only out of this when the PC has frozen is to power off and
> start again.

If you try CTRL+ALT+DEL W2K can't come back with a program not responding?
Unusual.

> When BNR is run up again the treads do the same thing.

Refresh one group at a time using one connection at a time. Otherwise,
you'll spend more time in locks (and possibly deadlocks) than anything. If
you're trying to do things automatically, consider splitting BNR3 into
multiple installations (one for each group or collection of groups).

> The version I am running is BNR3 1.0.123 which I think is the
> latest.  Systems is P4. 2.4G, win2K SP4, 512Meg ram.
(Continue reading)

margin_short | 1 Jun 15:45 2004
Picon
Picon

BNR3 Feature request for download directories

One thing I'd like to see in the "set a new directory for downloaded 
articles" is a history retention. The directories remain and can be 
selected from the drop down menu while a session is in progress but 
when BNR3 is closed they are deleted. Thanks for the great work on 
the Reapers!

PS. Another thing I'd like to see is a button near the FltCfg button 
which will clear the quick filter window and refresh the screen. As 
it is the filter text must be highlighted, deleted and the screen 
refreshed. 

Thanks again for this program.
margin_short

------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/dkFolB/TM
--------------------------------------------------------------------~-> 

Important Addresses:
Post message: bnr1 <at> yahoogroups.com
Group owner:  bnr1-owner <at> yahoogroups.com
BNR homepage: http://www.bnr2.org/

Yahoo! Groups Links

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

(Continue reading)

Howard Mori | 2 Jun 02:06 2004
Picon

Re: BNR2 stability

On reply to the stability of BNR2 release 13.3 , In my experiences with it, 
it is very unstable leading to constant crashes. It was driving me nuts.
I started using BNR3 with much success thus far. The only complaint is the 
slow refresh time but that is pety considering how long it takes to refresh 
an entire group after a crash! Good luck!

>From: Carsten Laekamp <carsten-bnr <at> laekamp.org>
>Reply-To: bnr1 <at> yahoogroups.com
>To: BNR Mailing List <bnr1 <at> yahoogroups.com>
>Subject: Re: [BNR] BNR2 stability
>Date: Mon, 31 May 2004 01:55:16 +0200
>
>On Sun, May 30, 2004 at 11:20:29PM +0200, Eduardo Delgado wrote:
>
> > Hi,
> >
> > Is it just me, or is 0.13.3 much less stable than previous releases? I 
>went
> > from 20-30 days to 3-5 days in database lifetime. I first start getting 
>a
> > MsgLst.log and then in one day or two it won't start. I don't think I'm 
>doing
> > anything different than before.
> >
> > Anyone with similar experiences?
>
>It does have serious database problems every 2-3 days here: it
>downloads only a few lines from one server/group but gets a normal
>amount of headers for the same group from other servers. Still,
>it doesn't show any new articles in that group after this
(Continue reading)

paul warner | 2 Jun 09:22 2004
Picon

Re: BNR3 What causes this ??

At 04:06 PM 6/2/2004, you wrote:

> > Several time I have found that BNR causes my PC to slow down and
>eventually
> > freeze.
>
>It may be hogging the system and not doing anything you consider useful
>(expiring headers), but I've never really seen BNR3 "freeze" here. But then,
>I use monitoring software so I can see all the reads/writes it is doing, and
>also how much CPU and RAM it is using.

The 2nd time this happened I left it 3 hours and it was still the same 
.  DU Meter shows no download traffic

> > The symptoms seem to be when the database gets to about the 500Meg
> > mark.  The server treads say "waiting for DBlock" and "Cleaning up
> > database"
>
>I don't think you're using the latest version. Please upgrade.
>
> >  The only out of this when the PC has frozen is to power off and
> > start again.
>
>If you try CTRL+ALT+DEL W2K can't come back with a program not responding?
>Unusual.

Only way to get out of it is to power down.

> > When BNR is run up again the treads do the same thing.
>
(Continue reading)

Werner-Yahoo | 2 Jun 09:31 2004
Picon

Re[2]: BNR3 What causes this ??

Hello paul,

Wednesday, June 2, 2004, 9:22:07 AM, you wrote:

pw> At 04:06 PM 6/2/2004, you wrote:

>> > Several time I have found that BNR causes my PC to slow down and
>>eventually
>> > freeze.
>>
>>It may be hogging the system and not doing anything you consider useful
>>(expiring headers), but I've never really seen BNR3 "freeze" here. But then,
>>I use monitoring software so I can see all the reads/writes it is doing, and
>>also how much CPU and RAM it is using.

pw> The 2nd time this happened I left it 3 hours and it was still the same 
pw> .  DU Meter shows no download traffic

>> > The symptoms seem to be when the database gets to about the 500Meg
>> > mark.  The server treads say "waiting for DBlock" and "Cleaning up
>> > database"
>>
>>I don't think you're using the latest version. Please upgrade.
>>
>> >  The only out of this when the PC has frozen is to power off and
>> > start again.
>>
>>If you try CTRL+ALT+DEL W2K can't come back with a program not responding?
>>Unusual.

(Continue reading)

Paul Warner | 2 Jun 22:46 2004
Picon

Re: BNR3 What causes this ??

At 07:11 AM 6/1/2004 -0500, you wrote:

> > Several time I have found that BNR causes my PC to slow down and
>eventually
> > freeze.
>
>It may be hogging the system and not doing anything you consider useful
>(expiring headers), but I've never really seen BNR3 "freeze" here. But then,
>I use monitoring software so I can see all the reads/writes it is doing, and
>also how much CPU and RAM it is using.

The 2nd time this happened I left it for 3 hours.  DUMeter shown no 
download in this time and I eventually slayed the app and restarted it

> > The symptoms seem to be when the database gets to about the 500Meg
> > mark.  The server treads say "waiting for DBlock" and "Cleaning up
> > database"
>
>I don't think you're using the latest version. Please upgrade.
>
> >  The only out of this when the PC has frozen is to power off and
> > start again.
>
>If you try CTRL+ALT+DEL W2K can't come back with a program not responding?
>Unusual.

The only way out is to power off the PC

> > When BNR is run up again the treads do the same thing.
>
(Continue reading)

ready_eddie_0 | 3 Jun 03:57 2004
Picon

Sqlite Optimization

Patrick, Jeff,

I came across a reference to this web page in the sqlite 
messagelist "old" archieves.  It's a bit out of the way, so I guessed 
you may not have come across it yet.  It's very incomplete, but it 
seems to contain some potential gems that I haven't seen elsewhere.

http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html

Regards

------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/dkFolB/TM
--------------------------------------------------------------------~-> 

Important Addresses:
Post message: bnr1 <at> yahoogroups.com
Group owner:  bnr1-owner <at> yahoogroups.com
BNR homepage: http://www.bnr2.org/

Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
     bnr1-unsubscribe <at> yahoogroups.com

(Continue reading)

ready_eddie_0 | 3 Jun 04:50 2004
Picon

What do you think? BNR3

OK, this is all with the sqlite.exe tool, not the BNR3.exe 
executable.  But it is operating on the MsgDB.bnr file.  The results 
surprised me somewhat and I wanted to see what other people's takes 
were on it.

Vacuum was taking forever on my 3 GB database, so I decided to try 
the other compression method to see how long that took:

   Step 1: .dump the whole database via sqlite.exe, result is sql 
ascii file (say MsgDB.sql)
   Step 2: create empty MsgDB.bnr file with sqlite.exe
   Step 3: .read the ascii file to regenerate the database

There are examples of this in the literature.

Step 1 completed in a minute or two and generated about 2.9 GB of 
SQL.  No problems (although I found that the special characters in 
the Subject table entries makes my PC do annoying beeps when I echoed 
them in the DOS window.  There are special character codes for 
author/filename/etc placeholders, right?).

Step 3 took overnight. According to taskmgr, during that time it 
expended 1 hour 9 minutes of CPU time ( <at> 3.2 Ghz).  It performed 28 GB 
of read I/O at roughly 500K/sec.  I had 20 GB of write I/O, at about 
500K/sec rate as well but more variable.  The end result was a 3 GB 
MsgDB.bnr file.

This seems excessive to me.  Is it possible that the BNR3 schema 
design is causing the sqlite routines to do a lot of extra work, 
especially when the tables get large?
(Continue reading)


Gmane