lol... Betrand i was not thinking you wouldn't know the internals, intimately. I was just trying to supply some context to my reply in case others were reading.
Actually, your term 'non-SQL' is used for KV systems and CouchDB, MongoDB are KV stores. I'm not sure about Solr... does it use those? So, this looks to me like a very interesting path for eZ. How far are you into doing this? -- Luc. On 23 June 2010 16:06, Bertrand Dunogier <[email protected]> wrote: > 2010/6/23 Luc Chase <[email protected]> > >> ez is based on an EAV data-model (allowing us to store any new >> content-class without changing the DB schema). But it results in the the >> DBMS we currently use (e.g. MySQL, etc.) which is designed for more >> conventional relational database designs, having to work very hard to >> execute fetches. KV stores are designed for systems such as eZ and are able >> to execute the same types of queries but more efficiently than a system >> which would have expected different content classes to be in different >> tables. The current situation is convenient and very good for a system that >> allows new classes at any time. But in terms of efficiency on the DBMS, it's >> like creating a dbms on a dbms. So, using a KV store I would expect a >> performance improvement for fetches of maybe hundreds or thousands of >> percent. And scalability issues would be fully resolved. >> > To be fully honest, as a member of the eZ engineering team, i'm quite aware > of how eZ Publish is structured :-) > > It is still a work-in-progress, but we are investing serious resources into > a more advanced content engine that would be able to use no-SQL databases > (sorry for the buzzword). We haven't investigated KV at all, but are > studying (and working on/with) CouchDB, MongoDB and more specifically Solr. > > KV looks interesting though, but I confirm we haven't explicitely > mentionned it so far. > > -- > Bertrand > > -- Luc. M. +44.7939 00 29 32 T. +44.2071939840 / +44.7040901582 Writing can be either readable or precise, but not at the same time. - Betrand Russell
-- Sdk-public mailing list [email protected] http://lists.ez.no/mailman/listinfo/sdk-public
