Hi, I have a db with a table collecting info about people (cca 330 000 rec.). The records have attribut Type which can be 1 or 2 or 3. The query is SELECT .. WHERE Type=1 AND Name LIKE "...". I rarelly restrict in one query agains people with different types ((ta.Type = 1 AND ta.Name LIKE "") AND (tcopy.Type = 2 AND tcopy.Name LIKE "")).
Is that better to divide this table into 3 tables with each holding info about persons of particular type?? I do not now how MySQL caches/buffers the tables when performing the query?? Thanx for any hint, and sorry if the question is too begginers' Miroslav Renda http://www.m7m.cz --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php