complex query qusetion

Hi, I'm looking at some search engine where we can have up to 14-15 categories and each categories have about 5-10 option (checkbox) my question is if we have a complex query like this would it be better to split some categories in tables i.e we have 21 different categories should we have 7 tabl

Index phpadmin

Hi, i have a quick question in phpadmin when i create an Index on an none empty table. i see that in Cardinality is either a number or has written None what does it mean?? Thank you Anthony

date and time

Hi, can someone explain me the avantage of using date and time, and also can i set time + XX minutes?? Thanx Anthony

efficient table

I tried to look everywhere @ mysql.com but i couldn't my question is how many records can a table handle so it stays fairly fast? What is the maximum records it can handle?? Thanx for any answers Anthony

Binary tree

Hi, I think MySQL uses binary tree, but my question is that what happens when we delete record. Does the binary regenerate itself?? thanx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]