← Back to team overview

openerp-expert-framework team mailing list archive

[Blueprint postgres-osv-memory] Alternative implementation of osv_memory using PostgreSQL

 

Blueprint changed by Numérigraphe:

Whiteboard changed:
  Please discuss this blueprint on the Framework Expert mailing list, and
  report only conclusions here.
  
  Basic proposition:
  osv_memory provides a convenient way to store transient data as in-memory objects.
  Currently this is used mainly for configuration wizards, but there are lots of other use cases for this.
  However the current implementation is incomplete and much slower than regular osv objects.
  In great part, this is due to the efficiency of PostgreSQL and the SQL language, as opposed to python code and hand-coded searches.
  Furthermore, PostgreSQL uses memory in a much smarter way, keeping data in memory only when it is used.
  So the conclusion is that we could implement osv_memory in a much better and simpler way by just adding a few missing features to the regular osv/orm:
  - data should be deleted when the server starts and stops
  - vaccum function
  
  Discussion:
  Some technical aspects have been emphasized: we could use sqlite or PG temporary tables (though we must take care of lifespan problems). Insisting on keeping objects in RAM may be a bad move.
  
  Implementation:
- This blueprint has been implemented in the trunk for v6.1.
+ This blueprint has been implemented in the trunk for v6.1 by the core team. Numerigraphe didn't do it but Launchpad insists on showing they did.

-- 
Alternative implementation of osv_memory using PostgreSQL
https://blueprints.launchpad.net/openobject-server/+spec/postgres-osv-memory