DecimalHi people,
Is there any procedure to make the group function faster?
I mean, i have a tabel with 200.000 record and about 8 fields, a command like:
---
select username,count(*) from table group by username
---
will take about 4/5 secunds
a simple select count(*) from table
will take 0.00045 secunds ( more or less )
here's the table description:
+---------------+---------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------+------+-----+---------------------+-------+
| username | varchar(255) | | MUL | | |
| filename | text | | | | |
| file_bytes | bigint(15) | | | 0 | |
| remote_host | varchar(255) | | | | |
| remote_ip | varchar(255) | | | | |
| command | varchar(255) | | | | |
| transfer_time | decimal(12,5) | | | 0.00000 | |
| date_time | datetime | | | 0000-00-00 00:00:00 | |
| info | varchar(2) | | | | |
+---------------+---------------+------+-----+---------------------+-------+
Jorge
