Re: Archtypes SQL Storage

Roch=E9 Compaan wrote:
> On Tue, 2006-10-10 at 16:16 -0700, Bill Schindler wrote:
>> My first attempt used Archetypes. That became excruciatingly slow when =

>> we loaded all of the data (many thousands of records). Archetypes is =

>> great for a broad range of Plone apps, but when you're dealing with lots =

>> of dynamic data, Archetypes is a bad fit.
> =

> I think the way SQLStorage is implemented is not optimal, but I do think
> it can fixed to easily allow interaction with a RDMBS. As such it is not
> an Archetypes deficiency but a SQLStorage one.

It was slow for us for both data via sql and data in the zodb. (And the =

zodb bloated fast because the data changes a lot.) I never tried to =

track down the reasons because I was looking for a working solution at =

the time, not to fix Archetypes.

> If I had to implement this, the first thing that I would do is  ...

I think what you're describing is very much like SQLWindowStorage in the =

Archetypes svn. But that seems to be not quite finished.

--Bill / bitranch


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easi=
er
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D1=
21642