>What would you recommend? Stick with flat files, mysql, mssql if
possible, berkeley, a mix?
Using flat files is the most worth option for V2 - but it should work for
the default setup (max 5 Workers and no warnings about too large hashes at
startup).
This depend on the size of the flat files. Use the RDBM (SQL) DB of your
choice (MySQL,MSSQL,Oracle,ProstgreSQL,DB2) for the main lists and hashes
and BerkeleyDB for the others.
In the past we had some problems using BerkeleyDB for the main hashes -
but this is fixed. Using BerkeleyDB for the main hashes needs more DB
knowledge, if more than 7 SMTP-Workers are running.
Thomas
Von: K Post <[email protected]>
An: ASSP development mailing list <[email protected]>
Datum: 17.03.2010 03:39
Betreff: Re: [Assp-test] DB_File
Excellent. I'll try this out in the morning and see what it reports.
I've always run our server without traditional databases and have just
have everything in flat files. We're seeing a startup memory usage of
around 700mb, growing to 1.3gb+ after it runs for a while. I am
asuming that using a database will greatly reduce that usage and speed
things up.
I want to continue to keep maintenance needs on this server low. I've
used mysql before, but i'm by no means an expert. I know MSSQL really
well, but presume that doesn't work with ASSP. I know nothing about
berkeleydb and have never run it.
What would you recommend? Stick with flat files, mysql, mssql if
possible, berkeley, a mix?
Your experience is appreciated.
Ken
On Tue, Mar 16, 2010 at 2:35 AM, Thomas Eckardt
<[email protected]> wrote:
> The module name is "DB_File" (case sensitive !!).
>
> Thomas
>
>
>
> Von: K Post <[email protected]>
> An: ASSP development mailing list <[email protected]>
> Datum: 15.03.2010 14:02
> Betreff: Re: [Assp-test] DB_File
>
>
>
> Using your suggestion, from the compress:zlib thread:
>
> C:\>perl -e "use db_file"
> Can't locate db_file.pm in @INC (@INC contains: C:/Perl/site/lib
> C:/Perl/lib .)
> at -e line 1.
> BEGIN failed--compilation aborted at -e line 1.
>
> Thanks
> On Mon, Mar 15, 2010 at 1:20 AM, Thomas Eckardt
> <[email protected]> wrote:
>> DB_File should be part of default Perl installation (Active Perl for
>> example)!
>>
>> Thomas
>>
>>
>> Von: K Post <[email protected]>
>> An: ASSP development mailing list <[email protected]>
>> Datum: 14.03.2010 21:25
>> Betreff: [Assp-test] DB_File
>>
>>
>>
>> Where can I find the DB_File perl module for windows 32? Is doesn't
>> seem to be in assp.mod.
>>
>> Thanks
>>
>>
>
------------------------------------------------------------------------------
>> Download Intel® Parallel Studio Eval
>> Try the new software tools for yourself. Speed compiling, find bugs
>> proactively, and fine-tune applications for parallel performance.
>> See why Intel Parallel Studio got high marks during beta.
>> http://p.sf.net/sfu/intel-sw-dev
>> _______________________________________________
>> Assp-test mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/assp-test
>>
>>
>>
>>
>> DISCLAIMER:
>> *******************************************************
>> This email and any files transmitted with it may be confidential,
> legally
>> privileged and protected in law and are intended solely for the use of
> the
>>
>> individual to whom it is addressed.
>> This email was multiple times scanned for viruses. There should be no
>> known virus in this email!
>> *******************************************************
>>
>>
>>
>
------------------------------------------------------------------------------
>> Download Intel® Parallel Studio Eval
>> Try the new software tools for yourself. Speed compiling, find bugs
>> proactively, and fine-tune applications for parallel performance.
>> See why Intel Parallel Studio got high marks during beta.
>> http://p.sf.net/sfu/intel-sw-dev
>> _______________________________________________
>> Assp-test mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/assp-test
>>
>
>
------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Assp-test mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
>
>
>
> DISCLAIMER:
> *******************************************************
> This email and any files transmitted with it may be confidential,
legally
> privileged and protected in law and are intended solely for the use of
the
>
> individual to whom it is addressed.
> This email was multiple times scanned for viruses. There should be no
> known virus in this email!
> *******************************************************
>
>
>
>
------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Assp-test mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
>
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Assp-test mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-test
DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally
privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no
known virus in this email!
*******************************************************
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Assp-test mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-test
