[ZODB-Dev] Advice needed

[Andreas Jung]

--On 24. Juni 2006 21:08:03 +0200 Dieter Maurer <dieter at handshake.de> wrote:

> Andreas Jung wrote at 2006-6-24 09:24 +0200:
>> ...
>> One particular app that I have been working on uses very complex queries
>> with lots of join etc....it would be hard model to implement such
>> queries  on top of the ZODB/ZCatalog.
>
> I disagree with you (partially).
>
>    The ZODB model (object data stored in a storage with behaviour
>    coded in the clients) is powerful enough to simply
>    implement the relational database data structures: tables
>    and indexes and their corresponding operations.
>
>    After this implementation, you could perform the same
>    complex queries against the records maintained in
>    these data structures.

Of course you *could*  do it but you can also shot yourself with a gun into 
your knee. You could also implement Zope on top of a touring machine ....
but nobody would do that :-)

>> Another point is performance: this app often
>> has to perform a lot of insert/update/delete operations within one
>> transaction (up to 1000 modifications).
>
> You would not believe how many objects your "TextIndexNG" modifies
> when it indexes a single document. Thousands is not very much ;-)
>

Patches are welcome :-)


-aj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 186 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zodb-dev/attachments/20060624/f7571edd/attachment.bin