hello, i have got a table "table1":
CREATE TABLE table1 ( id bigint(20) unsigned DEFAULT '0' NOT NULL auto_increment, refer varchar(255) NOT NULL, aantal int(9) DEFAULT '1' NOT NULL, time int(10) DEFAULT '0' NOT NULL, PRIMARY KEY (id), UNIQUE id (id) ); now i insert about 200 rows in it. After that i do i select (using phpMyAdmin): SELECT table1 FROM table1 it seems this never stops sending data: SHOW processlist: Id User Host db Command Time State Info 171807 _ _ Query 300 Sending data SELECT * FROM table1 also a delete like "DELETE FROM table1 WHERE time<........." will take (too) much time. All this give problems cause the table is locked when 'Sending data' and the row of new inserts is growing. Is there something wrong with my table-design? Thanks for reading. Bas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
