Skip to main content
Database Administrators
Phoenixy's user avatar
Phoenixy's user avatar
Phoenixy's user avatar
Phoenixy
  • Member for 6 years
  • Last seen more than 1 year ago
  • hearthstonehungary.hu
  • Budapest
Profile Activity

9 Actions

All Accepts Posts Badges Comments Revisions Reviews Suggestions
comment
Simple update query slow in php, quick in phpmyadmin
I don't know what I should be doing. Explain gave me this: 1;SIMPLE;comment;range;PRIMARY,id;id;4;NULL;1;Using where
asked
Simple update query slow in php, quick in phpmyadmin
comment
Slow query with multiple group by
No, that's fine. Because even if there are 10 new comments to the same topic, it should be 1 notification only. Sorry if I wrote it wrong.
revised
Slow query with multiple group by
added more details
comment
Slow query with multiple group by
It gets all the comments from threads (topics, news, pcitures) where a given user has commented and not yet seen the comment. Updated above.
awarded
 Editor
revised
Slow query with multiple group by
added 367 characters in body
awarded
 Autobiographer
asked
Slow query with multiple group by