Re: alias or nodenumber

[Paul van Beukering]

> Why don't you use: > > usernode - related - result - related - gametype We expect lot's of users. In the passed I had difficulties with query performance, so now I want to reduce the number of relations as much as possible. Want to achieve this by relating as follows. usernode - resultrelated - result   Does this cut wood? ahum   ----- Original Message ----- From: Paul van Beukering To: [EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 11:59 AM Subject: alias or nodenumber As an end user of MMBASE I would like feedback on the following situation:   I make a site for users playing several type of games. All game results are put in a result object. Now, I would like to make the following relation: usernode - resultrel - result resultrel tells me which type of game was played for a user. I hesitate to use a nodenumber as field in resultrel, I would say it's better to use an alias of a gametype as resultrel field? Am I correct and can I just use a string field for alias as resultrel field?   Thanks in advance, Paul