Hi there, I have a user table with lots of different column types. Now I do experiance problems filtering out special date. The performance is really bad. So maybe I did just pick the wrong column types?!
This is what I picked so far: | Type | Null | Key | Default | Extra | mediumint(8) unsigned | | PRI | NULL | auto_increment | varchar(100) | | | | | varchar(20) | | | | | timestamp(14) | YES | | NULL | | char(1) | | | | | char(1) | | | | | varchar(100) | | | | | varchar(100) | | | | | mediumint(9) | YES | MUL | NULL | | tinyint(2) unsigned | | | 0 | | char(1) | | | 0 | | char(2) | | MUL | | | char(2) | | MUL | 0 | | varchar(100) | | | | | varchar(255) | | | | | tinyint(1) unsigned | | | 0 | | varchar(32) | | | | | varchar(15) | | | | | varchar(32) | | | | | tinyint(1) unsigned | | | 0 | | tinyint(3) unsigned | | | 1 | | smallint(5) unsigned | | | 0 | | varchar(255) | YES | | NULL | | varchar(9) | YES | | NULL | | varchar(100) | YES | | NULL | | tinyint(3) unsigned | | | 0 | Maybe someone knows what I do wrong. Thank you for any help on that mysql table. Andy --------------------------------------------------------------------- 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