Yo, i was wondering if there are any tests done performance wise, i have 1400+ teams in my database now, but loading the team page takes a looooong time or even times out.

I have been trying to find out where the performance hits lies but i have no idea..

The connection table to the users contains over 7379 records.

anyone?

well, i did found out what the problem was.

There are NO indexes setup on the regular database setup. Because of this this query:

SELECT c. * , COUNT( m.id ) AS members
FROM _teams AS c
LEFT JOIN _teams_members AS m ON m.teamid = c.id
GROUP BY c.id
ORDER BY c.name ASC
LIMIT 0 , 20

this one really hanged, TAKING 17 SECONDS!!

i used, explain to see what to do. I added an index on m.id and on c.id. Now the query is ALOT faster (taking only 0.3 seconds)

So if this helps anyone..