DELETE doesn't delete?

2004-06-26 Thread Margaret MacDonald
It's possible that this is more a php question than a mysql question, but since the two are so nearly joined at the hip, I'm hoping someone can advise anyhow. I'm developing a php job that uses a table 'sessions' to maintain a logical session across pages and physical sessions. It's a simple tabl

Cost of joins?

2004-07-09 Thread Margaret MacDonald
Is there a generally-accepted rule of thumb for estimating the performance cost of joins? I can't find one even in Date, but intuitively it seems as though there must be one by now. I'm thinking of something like 'if not doing anything costs 0, and reading 1 table costs 100, then joining a secon