guys, I am seeing tons of queries like this one in the show process: SELECT * FROM fe_sessions,fe_users WHERE fe_sessions.ses_id = 'e361c16a9f' AND fe_sessions.ses_name = 'fe_typo_user' AND fe_sessions.ses_userid = fe_users.uid AND (fe_sessions.ses_iplock='38.99'OR fe_sessions.ses_iplock='[DISABLED]') AND fe_sessions.ses_hashlock=268278894 AND fe_users.disable=0 AND fe_users.deleted=0 AND (fe_users.starttime<=1238029426) AND (fe_users.endtime=0 OR fe_users.endtime>1238029426)
I added indexes on fe_sessions.ses_userid and fe_sessions.ses_hashlock but it did not help much. First, why suddenly I am seeing this selects? What code are they from? And should I use MyISAM or InnoDB for these fe_sessions and fe_users tables? I am using InnoDB. _______________________________________________ TYPO3-english mailing list [email protected] http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
