Re: [ZODB-Dev] Does ZODB pipeline load requests?

2014-02-19 Thread Dylan Jay
On 20 Feb 2014, at 2:27 am, Jim Fulton wrote: > On Wed, Feb 19, 2014 at 9:57 AM, Dylan Jay wrote: >> On 19 Feb 2014, at 10:44 pm, Jim Fulton wrote: > ... >> yeah I figured it might be the case thats its hard to predict. In this case >> it's catalog indexing so

Re: [ZODB-Dev] Does ZODB pipeline load requests?

2014-02-19 Thread Dylan Jay
On 19 Feb 2014, at 10:44 pm, Jim Fulton wrote: > On Tue, Feb 18, 2014 at 8:59 PM, Dylan Jay wrote: >> Hi, >> >> I'm seeing a a ZCatalog reindex of a large number of objects take a long >> time while only using 10% cpu. I'm not sure yet if this is d

[ZODB-Dev] Does ZODB pipeline load requests?

2014-02-18 Thread Dylan Jay
ol I didn't see a way for code such as the ZCatalog to give a hint to ZEO as to what they wanted to load next so the time is taken by network delays rather than either ZEO or app. Is that the case? I'm guessing if it is, it's a fundamental design problem that can't be fixed :

Re: [ZODB-Dev] polite advice request

2013-08-19 Thread Dylan Jay
In some ways the ZODB is less flexible. It requires you to understand more about how you will access the data before you import it, than does an SQL database. This is because the datastructure defines how you can query it in a ZODB. For example, if you need multiple indexes to your data, then t

[ZODB-Dev] slow page requests using relstorage with mysql

2013-07-22 Thread Dylan Jay
<- 406.4706.478 transformer.py:24(__call__) {method 'query' of '_mysql.connection' objects} <- 1483.6613.661 cursors.py:277(_do_query) ... The page itself is just a normal page, no writes involve

[ZODB-Dev] Fwd: Zope/Plone/Zeo Concurrency Issue

2013-05-28 Thread Dylan Jay
Hi, My colleague is having the issue outlined below. I thought this list might be better to give an insight as to what is going on? Begin forwarded message: > From: Adam Terrey > Subject: Fwd: Zope/Plone/Zeo Concurrency Issue > Date: 28 May 2013 5:23:33 PM AEST > T

Re: [ZODB-Dev] shared cache when no write?

2012-12-17 Thread Dylan Jay
On 18/12/2012, at 2:15 PM, Leonardo Rochael Almeida wrote: > Hi, > > On Mon, Dec 17, 2012 at 10:03 PM, Dylan Jay wrote: >> >> On 14/12/2012, at 8:32 AM, Jim Fulton wrote: >> >>> On Thu, Dec 13, 2012 at 4:18 PM, Dylan Jay wrote: >>> ...

Re: [ZODB-Dev] shared cache when no write?

2012-12-17 Thread Dylan Jay
On 14/12/2012, at 8:32 AM, Jim Fulton wrote: > On Thu, Dec 13, 2012 at 4:18 PM, Dylan Jay wrote: > ... >> I'd never considered that the cache was attached to the db connection rather >> than the thread. I just reread >> http://docs.zope.org/zope2/zope2book/Mai

Re: [ZODB-Dev] shared cache when no write?

2012-12-13 Thread Dylan Jay
On 13/12/2012, at 11:07 PM, Jim Fulton wrote: On Wed, Dec 12, 2012 at 6:31 PM, Dylan Jay wrote: Hi, I've been working with zope for over 12 years and something that keeps coming up is sacling IO bound operations in Zope. The typical example is where you build an app that calls ext

[ZODB-Dev] shared cache when no write?

2012-12-12 Thread Dylan Jay
Hi, I've been working with zope for over 12 years and something that keeps coming up is sacling IO bound operations in Zope. The typical example is where you build an app that calls external apis. While this is happening a zope thread isn't doing any other processing and because there is a 1 th

Re: [ZODB-Dev] Relstorage and MSQL

2012-05-16 Thread Dylan Jay
On 16/05/2012, at 3:24 AM, Alan Runyan wrote: Windows 2008 server standard. Python 2.6/2.7 I'm not sure. I think living without clustering and memcached for the moment is fine. I would agree. And what about blob storage? Are blobs inside the DB in little chunks enough, do you want them

Re: [ZODB-Dev] Relstorage and MSQL

2012-05-08 Thread Dylan Jay
On 09/05/2012, at 11:26 AM, Hanno Schlichting wrote: On 09.05.2012, at 02:34, Dylan Jay wrote: I know it's not all about money but if we were to sponsor development of microsoft sql server support for relstorage, is there someone who knows how and has an estimated cost and available

[ZODB-Dev] Relstorage and MSQL

2012-05-08 Thread Dylan Jay
Hi, Previous threads on this subject didn't seem to go anywhere. I know it's not all about money but if we were to sponsor development of microsoft sql server support for relstorage, is there someone who knows how and has an estimated cost and available time? --- Dylan Jay

Re: [ZODB-Dev] RelStorage - How can I set up one database per web site?

2011-10-17 Thread Dylan Jay
Sorry for the confusion It is a buildout feature to make your variable substitutions which is what Ive done there. Replicas are for redundant MySQL servers. I doubt you need that. Just check the relstorage docs to see what options you need. Dylan Jay Technical solution manager PretaWeb 99552830

Re: [ZODB-Dev] RelStorage - How can I set up one database per web site?

2011-10-12 Thread Dylan Jay
shared-blob-dir off replica-conf ${mysql-hosts:output} db blah user blah passwd blah --- Dylan Jay Technical Solutions Manager PretaWeb: Multisite Performance Support

Re: [ZODB-Dev] Sharing (persisted) strings between threads

2010-12-08 Thread Dylan Jay
Dylan Jay Technical solution manager PretaWeb 99552830 On 08/12/2010, at 11:28 PM, Jim Fulton wrote: > On Wed, Dec 8, 2010 at 5:06 AM, Malthe Borch wrote: >> Currently, when a thread loads a non-ghost into its object cache, its >> straight from being unpickled. That means that

[ZODB-Dev] ClientDisconnected with ZEORaid

2010-05-24 Thread Dylan Jay
tion is abandoned. --- Is there any good reason not to retry connecting? --- Dylan Jay Plone Solutions Manager. www.pretaweb.com P +612 80819071 M +61421477460 skype - dylan_jaytwitter - djay75 ___ For more information about ZODB, see the ZODB

[ZODB-Dev] Re: ERROR ZODB.Connection Couldn't load state for 0x01

2008-03-12 Thread Dylan Jay
Chris Withers wrote: the main db and created a new one and remounted the other two. Luckly nothing was in the main db except the mount points. Then why are you using mounted dbs? I have seperate plone sites in each mounted db. This lets me move them between servers, or between production an

[ZODB-Dev] Re: ERROR ZODB.Connection Couldn't load state for 0x01

2008-03-10 Thread Dylan Jay
Chris Withers wrote: Dylan Jay wrote: I have a few databases being served out of a zeo. I restarted them in a routine operation and now I can't restart due to the following error Do you use cross database references? not to my knowledge. I had 1 main db and 2 mounted db's which

[ZODB-Dev] ERROR ZODB.Connection Couldn't load state for 0x01

2008-03-09 Thread Dylan Jay
hi, I have a few databases being served out of a zeo. I restarted them in a routine operation and now I can't restart due to the following error Any idea on how to fix this? 2008-03-10 06:29:12 ERROR ZODB.Connection Couldn't load state for 0x01 Traceback (most recent call last): File "/ho

[ZODB-Dev] asymetric cache sizes

2006-03-21 Thread Dylan Jay
growing and shrinking like in the latest zope? -- Dylan Jay --- ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev

[ZODB-Dev] Generational Caching

2005-06-07 Thread Dylan Jay
mised. -- Dylan Jay ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev