Re: Help indexing this query.

time<2008-06-08+INTERVAL 1 DAY >> >> AND e.mid IS NULL >> >> GROUP BY s.mid >> >> HAVING earned>0 >> >> ORDER BY earned DESC >> >> >> >> --- problem --- >> >> >> >> `pts

Re: Help indexing this query.

gt;> calculate >> a sum of how much they earned. Then I reorder that sum in Descending >> order >> so the highest earned is on top. >> >> This `ptsSignups` table contains 82752 rows and is 75KB big. It runs >> extremely slow. I tried to create an index for it b

Re: Help indexing this query.

le `ptsSignups` by member id, and >> calculate >> a sum of how much they earned. Then I reorder that sum in Descending >> order >> so the highest earned is on top. >> >> This `ptsSignups` table contains 82752 rows and is 75KB big. It runs >> extremely s

Re: Help indexing this query.

ate an index for it but it failed to increase performance. Any help is appreciated. -- View this message in context: http://www.nabble.com/Help-indexing-this-query.-tf3059045.html#a8505554 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For l

Help indexing this query.

s `ptsSignups` table contains 82752 rows and is 75KB big. It runs extremely slow. I tried to create an index for it but it failed to increase performance. Any help is appreciated. -- View this message in context: http://www.nabble.com/Help-indexing-this-query.-tf3059045.html#a8505554 Sent from the