#  $HeadURL$ $LastChangedRevision$

Wed  5 Feb 14:44:54 CET 2025

MPCDF "disaster" scripts use rocon, with approximately 2600 hosts.
This was giving performance problems (e.g. 130s to work out of 
the user had included IO or Master hosts specifiers for disaster
scenarios where such hosts were not appropriate).

To solve this, my first thought was to use SQLite. In the end
that was not necessary (I solved the performance issues a different
way). But while I was still considering SQLite I ran into some
issues with the stock sqlite3 command and library. Namely:

1) it does not support ~2600 *columns*

2) the sqlite shell, sqlite3, can't take command lines with 15k
   characters in them.

I therefore compiled sqlite from source. These are my notes.

1) Visit //www.sqlite.org/download.html.

2) Down sqlite-autoconf-3480000.tar.gz.

3) Unpack.

4) Edit sqlite3.c and set:

       #define SQLITE_MAX_EXPR_DEPTH 5000

       #define SQLITE_MAX_COLUMN 10000

   (Both these symbols are already present but with lower values)

5) Install the package readline-dev.

6) Run:

       ./configure --enable-readline
       make

--