Hello, I am currently creating a multi-user system which has approximately 15 tables. Each table has a primaryID as well as the userID of who this record belongs to. Therefore, when I perform a SELECT I am checking (potentially) both the primaryID column as well as the userID. I'm using MyISAM tables.
Assuming I have a valid index on each table of (primaryColumn, userID) is there much of a performance loss doing this? While storing the userID is not technically necessary (since each primary column has the UNIQUE attribute) I find it much simpler to know who a row belongs to just by checking the ID rather than tracing back the various relations that will link said row/table back to a user. Any advice would be appreciated, Russ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
