[IPython-dev] On sqlite history performance improvements...

[Fernando Perez]

On Sat, Apr 9, 2011 at 2:09 PM, Thomas Kluyver <takowl at gmail.com> wrote:
> I'll make a branch for you to test.

Great, thanks!

>> - we also need to expose the cache parameter as a configurable, though
>> this may need to wait for the config work to be completed, not sure
>> right now if the history object is already accessible to the config
>> file mechanisms.
>
> It should already be exposed:
> db_cache_size = Int(0, config=True)

Yup, you're right.  Putting this in the config file:

c.HistoryManager.db_cache_size = 10

makes the default cache size be 10.

> Perhaps there's scope for a more general magic to change those config
> options which can be changed while we're running. Something like:
>
> %ipconf history_db_cache 10
> %ipconf history_db_log_output true

Absolutely.  Let's hold off on this though until we sort out the
config work, since the implementation details of such a magic would
likely depend on that.

Cheers,

f