> Concerning URI length: I am with Christophe here: half the world > restricts URIs to 255 characters and it should be enough for "normal" > applications. As almost every request accesses the URI table it might be > a performance problem using blobs. So I would propose to leave this for > the default implementation.
OK, for me - for now. Thought it looks like the same old jdbc-mysql-schema-mistake: BLOBs for uri - but pk(255) .. Silly! I've attached an updated mysql-schema, how I think it should look like. The delta is: - tinyint for Booleans, - dropped indexes (because primary and unique are indexes) - Single or first unique became primary Now, the bad news: I hadn't got any time testing this. So, if you check this and it doesn't work - dump it. But if it do work for you, I wouldn't be surprised it do it quite a bit faster (insert and delete with less indexes). regards, alex
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
