It should be possible to use SQLite for the main hashes. No way to use a
RDB for the temporary hashes, this would lead in toooooo many concurrent
connection to the database listener and would slow down assp dramaticaly.
There are possibly needs to create the SQL statements fragments for SQLite
in the assp_db_import.cfg. And it must be tested, which is the maximum
record count that could be inserted in to SQLite with a single INSERT
statement.
It is also possible, that a code change is needed, if SQLite is unable to
work with the 'default' data formats 'varbinary' and 'integer'.
'default' => [qw/ varbinary(254) varbinary(255) integer 0
0 /], #others
If anyone is crazy enough to spend some time on that, I'll help to change
the code and to create the record(s) for the assp_db_import.cfg - but
I'll never install SQLite!
Thomas
Von: "GrayHat" <gray...@gmx.net>
An: <assp-test@lists.sourceforge.net>
Datum: 02.11.2011 10:15
Betreff: [Assp-test] ASSP: SQLite ?
I was wondering if ASSP may achieve some slight improvement
by using SQLite instead of BerkeleyDB for one, the BDB is probably
faster, but, on the other hand, SQLite may possibly have a smaller
memory footprint while allowing ASSP to run over a self-contained,
full SQL database
http://www.sqlite.org/
http://search.cpan.org/~msergeant/DBD-SQLite-0.31/lib/DBD/SQLite.pm
crazy idea ?
------------------------------------------------------------------------------
RSA® Conference 2012
Save $700 by Nov 18
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
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!
*******************************************************
------------------------------------------------------------------------------
RSA® Conference 2012
Save $700 by Nov 18
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
