On Feb 10, 2008 5:30 PM, Yves Goergen [EMAIL PROTECTED] wrote:
My problem is that the sub-select in line 7 (SELECT 1) takes a rather
long time. (When I remove it, it's much faster.)
This is a known issue with EXISTS/NOT EXISTS subqueries in MySQL,
which has some fixes slated for MySQL 6. In
On 11.02.2008 19:51 CE(S)T, Perrin Harkins wrote:
On Feb 10, 2008 5:30 PM, Yves Goergen [EMAIL PROTECTED] wrote:
My problem is that the sub-select in line 7 (SELECT 1) takes a rather
long time. (When I remove it, it's much faster.)
This is a known issue with EXISTS/NOT EXISTS subqueries in
Yves
Is there some way to get only the headlines ...
For brief discussion some examples see 'The [Not] Exists query
pattern' at http://www.artfulsoftware.com/infotree/queries.php.
PB
Yves Goergen wrote:
On 11.02.2008 19:51 CE(S)T, Perrin Harkins wrote:
On Feb 10, 2008 5:30 PM, Yves
On Feb 11, 2008 4:46 PM, Yves Goergen [EMAIL PROTECTED] wrote:
Thank you for the link. Is there some way to get only the headlines and
a summary for all entries? Reading through the entire contents by month
and finding the misleading captions is hard work for such masses of
content. The search
Yves
If user.additionalkeylist and tag.readaccesskeylist are not lists,
naming them `...list` misleads distracts.
You asked earlier how to fit my preliminary solution into your problem.
The answer is to (i) write the query that lists access-denied messages,
then (ii) write a simple
Yves,
Okay. Then the long form.
1. user.additionalkeylist and tag.readaccesskeylist are atomic despite
their names?
2. You have reciprocal foreign keys, keylist.key referencing
user(userID) and user.additionalkeylist referencing keylist.keylistID?
PB
Yves Goergen wrote:
On 11.02.2008
On 11.02.2008 20:13 CE(S)T, Peter Brawley wrote:
If user.additionalkeylist and tag.readaccesskeylist are not lists,
naming them `...list` misleads distracts.
Well, these fields contain KeylistId values from the keylist table, so
I thought naming them *Keylist would be good enough.
But on
On 11.02.2008 17:32 CE(S)T, Peter Brawley wrote:
1. user.additionalkeylist and tag.readaccesskeylist are atomic despite
their names?
Yes, I forgot the types. Everything is scalar, varchar or integer. There
are not set or otherwise complex data types.
2. You have reciprocal foreign keys,
On 11.02.2008 00:29 CE(S)T, Peter Brawley wrote:
message (messageID)
keylist (keylistID)
tag ( tagID, readaccesskeylist references keylist(keylistID) )
message_revision_tag ( ???, messageID references message(messageID),
tagID references tag(tagID))
Another table:
message_revision(MessageId
On 11.02.2008 11:18 CE(S)T, Peter Brawley wrote:
Unclear.
Okay. Then the long form.
My application is a messaging application that supports multiple users,
messages with revisions, tags and access control.
A user is identified by a UserId which I also call key. (Imagine it
like the key
Yves
it will rather find messages that have no tag with a keylist
which does not include the currently logged in user's UserId
or one of this user's additional keys, which are again stored
in a keylist.
Unclear.
PB
Yves Goergen wrote:
On 11.02.2008 00:29 CE(S)T, Peter Brawley wrote:
message
Hi,
I have a performance problem with one of my SQL queries. It's a rather
complex one so I'll spare you the details. This is the situation:
In my system, there's messages, tags and keylists. Each message has
message_revisions, each message_revision can be assigned tags (stored in
Yves,
My problem is that the sub-select in line 7
(SELECT 1) takes a rather long time
It might be possible to simplify. Do I have the schema right?
message (messageID)
keylist (keylistID)
tag ( tagID, readaccesskeylist references keylist(keylistID) )
message_revision_tag ( ???, messageID
13 matches
Mail list logo
