Re: sqlite in BNR3 under Vista

JohnB said

> --- In [email protected], Dave Warren <lists@...> wrote:
>>
>> On Wed, 14 Oct 2009 23:55:09 +0200, Evzen Polenka <evzen@...> was
>> claimed to have wrote:
>> 
>> >From: JohnB
>> >Sent: 14.10.2009 22:25
>> >
>> >>  I wonder if I should update the sqlite.dll that I have in my BNR3
>> >>  application to the latest level?
>> >
>> >AFAIK you need SQLite 2.x for BNR3, but the latest SQLite version is
>> >3.x => no, you should not upgrade to the latest (i.e. 3.x) version...
>> >But you can upgrade to the latest 2.x version...
>> >
>> >Please someone correct me if I'm wrong.
>> 
>> That sounds correct, but I haven't personally tested.
>>
> thanks.  I will probably try a later level of sqlite 2.x  I did tweak
> the db settings and have improved response some.

Yep anything from the 2.x branch.

As for the db/page settings I have now got BNR3 faster in every way than
BNR2 is ...execpt if the que page is greater than 5 GB and you sort it,
and loading the files in from big.multi .nzb files are some 20/30x faster
in 3 now, this was the only reason I had still been using BNR2 (nzb files).

I have said (and posted batch files) so many times about setting the
db/page sqLite settings to your computer its sort of nice to hear that
some had understood.

L_N

-- 
Imagine if there were no hypothetical situations...




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

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/