> Problem 1: > > select id_group, count(id) > group by id_group > > This takes a couple of minutes,
Is that the entire query? No where clause? I don't think any database is going to use the index when you aren't providing a where clause... especially when you have a count and a group by in there... it has to read the entire table.
