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!
Do not quite understand. What is silly here?
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).
What do you say, Christophe? If you agree I will make the modifications...
Oliver
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
