Re: [ZODB-Dev] grab zodb dict keys by search term

2013-12-10 Thread Darryl Dixon - Winterhouse Consulting
/transformation of that data in Python after extracting it with SQL (and then re-storing it again afterwards), instead now you can just directly process the data as if it was in Python objects waiting the entire time. Hope this helps. regards, Darryl Dixon Winterhouse Consulting Ltd Hi people! I am

[ZODB-Dev] Implications of eliminating use of ZOID_SEQ in Oracle

2013-09-16 Thread Darryl Dixon - Winterhouse Consulting
) are very fast when we have tested them. Questions: * What downsides can the audience here anticipate? * What are the chances that a change like this could make it in to the core RelStorage distribution? * Any other considerations that anyone can comment on? regards, Darryl Dixon Winterhouse

Re: [ZODB-Dev] ZeoServer, multiple storages and open file handles

2012-10-24 Thread Darryl Dixon - Winterhouse Consulting
Dieter talks about the vote phase on large transactions preventing other requests from running. I have seen this happen in practice (with 2GB transactions) and other requests were, without doubt, prevented from being serviced during this phase. I hope this helps, regards, Darryl Dixon Winterhouse

Re: [ZODB-Dev] zeopack error

2012-02-09 Thread Darryl Dixon - Winterhouse Consulting
Pickler.dump() OFS.File objects bigger than 32mb :-) Cheers, Darryl Dixon Winterhouse Consulting Ltd http://www.winterhouseconsulting.com ___ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org

Re: [ZODB-Dev] Transaction notes

2011-11-15 Thread Darryl Dixon - Winterhouse Consulting
instead an 'empty' transaction that has no actual changed data, but which still calls 'commit()'; then the answer is still 'no' and the reason is simple - against which database would the note be written? Cheers, Darryl Dixon Winterhouse Consulting Ltd http://www.winterhouseconsulting.com

Re: [ZODB-Dev] RelStorage - high ConflictError rate in newly converted DB

2011-11-10 Thread Darryl Dixon - Winterhouse Consulting
Hi Shane, On 11/07/2011 03:15 PM, Darryl Dixon - Winterhouse Consulting wrote: Hi All, We have just converted a site with a handful of editors over from ZEO to RelStorage on Oracle and and the rate of ConflictErrors has gone through the roof (5 an hour average continuously for days

[ZODB-Dev] RelStorage - high ConflictError rate in newly converted DB

2011-11-07 Thread Darryl Dixon - Winterhouse Consulting
to lower this back down? We used to use ZEO with an invalidation-queue-size of 5000 and a client-cache of 1000. Currently we are using a very basic RelStorage configuration without any additional bits like memcache. Any guidance gratefully appreciated. regards, Darryl Dixon Winterhouse Consulting Ltd

Re: [ZODB-Dev] RelStorage with Oracle and separation of rights

2011-11-02 Thread Darryl Dixon - Winterhouse Consulting
Hi Shane, On 10/30/2011 07:05 PM, Darryl Dixon - Winterhouse Consulting wrote: Hi All, Part of the setup of our Oracle RelStorage environment involves the DBAs wanting to separate ownership of the schema from the rights to actually use the schema. In other words, user A owns all the tables

[ZODB-Dev] RelStorage with Oracle and separation of rights

2011-10-30 Thread Darryl Dixon - Winterhouse Consulting
that other such situations may arise involving, eg Indexes or Sequences. Is there any straightforward way to resolve this? regards, Darryl Dixon Winterhouse Consulting Ltd http://www.winterhouseconsulting.com ___ For more information about ZODB, see http

[ZODB-Dev] RelStorage - zodbconvert script and the --clear flag

2011-08-31 Thread Darryl Dixon - Winterhouse Consulting
of to following this suggestion in this instance? regards, Darryl Dixon Winterhouse Consulting Ltd http://www.winterhouseconsulting.com ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev

Re: [ZODB-Dev] RelStorage - zodbconvert script and the --clear flag

2011-08-31 Thread Darryl Dixon - Winterhouse Consulting
referenced by enabled foreign keys So I guess without a bunch of work it will not be possible. regards, Darryl Dixon Winterhouse Consulting Ltd http://www.winterhouseconsulting.com ___ For more information about ZODB, see the ZODB Wiki: http

[ZODB-Dev] RelStorage: Error Installing Plone Site on Oracle RAC

2010-12-02 Thread Darryl Dixon - Winterhouse Consulting
this? regards, Darryl Dixon Winterhouse Consulting Ltd http://www.winterhouseconsulting.com ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman

Re: [ZODB-Dev] RelStorage: Error Installing Plone Site on Oracle RAC

2010-12-02 Thread Darryl Dixon - Winterhouse Consulting
. Anyone who can shed some light? regards, Darryl Dixon Winterhouse Consulting Ltd http://www.winterhouseconsulting.com ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https

Re: [ZODB-Dev] zodb monitor port / tailing a .fs

2010-10-14 Thread Darryl Dixon - Winterhouse Consulting
On 14/10/2010 02:40, Darryl Dixon - Winterhouse Consulting wrote: ...and fsdump appears to have no way of saying show me the last few transactions in this 35GB file :-( Yeah it's pretty verbose. I usually just pump the output to a text file ...yeah, but a 35GB zodb is going to result

Re: [ZODB-Dev] zodb monitor port / tailing a .fs

2010-10-13 Thread Darryl Dixon - Winterhouse Consulting
pretty close (ZODB/scripts/fsdump.py). Between that and the Undo log for the DB inside Zope, you might be able to figure it out... regards, Darryl Dixon Winterhouse Consulting Ltd http://www.winterhouseconsulting.com ___ For more information about ZODB

Re: [ZODB-Dev] zodb monitor port / tailing a .fs

2010-10-13 Thread Darryl Dixon - Winterhouse Consulting
) it has a typo bug where Main() calls Main(path, ntxn) instead of main(path, nxtn) (note capitalisation). regards, Darryl Dixon Winterhouse Consulting Ltd http://www.winterhouseconsulting.com ___ For more information about ZODB, see the ZODB Wiki: http

Re: [ZODB-Dev] zodb monitor port / tailing a .fs

2010-10-13 Thread Darryl Dixon - Winterhouse Consulting
On 14/10/2010 01:28, Darryl Dixon - Winterhouse Consulting wrote: Do we have any kind of tail -f /some/filestorage.fs yet? (or have we always had such a tool) to see what the last few transactions in the underlying file storage look like in a human-readable form? fsdump.py gets you pretty

[ZODB-Dev] RelStorage on Oracle RAC (doing now)

2010-03-09 Thread Darryl Dixon - Winterhouse Consulting
--[cut] many regards, Darryl Dixon Winterhouse Consulting Ltd http://www.winterhouseconsulting.com ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https