On 01/02/2011 14:42, Stephan Richter wrote:
> On Tuesday, February 01, 2011, Chris Withers wrote:
>> I also note that while the ones with lots of tables have this schema for
>> object_state:
>>
>> CREATE TABLE `object_state` (
>> `zoid` bigint(20) NOT NULL,
>> `tid` bigint(20) NOT NULL,
>> `state` longblob,
>> PRIMARY KEY (`zoid`)
>> ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$
>>
>> ...the one with only two tables has this schema:
>>
>> CREATE TABLE `object_state` (
>> `zoid` bigint(20) NOT NULL,
>> `tid` bigint(20) NOT NULL,
>> `state` longblob,
>> PRIMARY KEY (`zoid`)
>> ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$
>
> Did you paste correctly? They seem identical to me.
Nope, I phail... but the above is the incorrect version.
Try creating a RelStorage and you'll see.
The above ends up being really slow as it has no index on tid...
cheers,
Chris
--
Simplistix - Content Management, Batch Processing & Python Consulting
- http://www.simplistix.co.uk
_______________________________________________
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/listinfo/zodb-dev
