[PHP-DB] select take (too) much time From: Bas Jobsen (bas <email protected>)
Date: 10/30/01

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: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>