Login

08-03-2010, 01:50 PM

[eluser]RaZoR LeGaCy[/eluser]
Table holding only 1500 records.

I have on every page load from ci_sessions. One select statement and 5 updates.

Should I switch my session class, if so then to what session? Can I fix the session class?

I use Freakauth_light with it's own session (http://www.koders.com/php/fid8728438C6B3...px?s=login).
Can I just drop it and use another session like http://codeigniter.com/wiki/Session_Hybrid/

Output from profiler

Code:
TOP OF PROFILER

SELECT * FROM (`ci_sessions`) WHERE `session_id` = '248d49d92b046c60ee69245c0dfc63a9' AND `last_activity` > 1280855860  Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Speed: 0.001 ms

UPDATE `ci_sessions` SET `last_activity` = 1280863060, `user_agent` = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', `ip_address` = 'XX.XXX.XX.XXX', `session_data` = 'DATA:I REMOVED FOR SECURITY}' WHERE session_id = '248d49d92b046c60ee69245c0dfc63a9'

UPDATE `ci_sessions` SET `last_activity` = 1280863060, `user_agent` = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', `ip_address` = 'XX.XXX.XX.XXX', `session_data` = 'DATA:I REMOVED FOR SECURITY}' WHERE session_id = '248d49d92b046c60ee69245c0dfc63a9'

UPDATE `ci_sessions` SET `last_activity` = 1280863060, `user_agent` = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', `ip_address` = 'XX.XXX.XX.XXX', `session_data` = 'DATA:I REMOVED FOR SECURITY' WHERE session_id = '248d49d92b046c60ee69245c0dfc63a9'

MIDDLE OF PROFILER

UPDATE `ci_sessions` SET `last_activity` = 1280863060, `user_agent` = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', `ip_address` = 'XX.XXX.XX.XXX', `session_data` = 'Removed for security}' WHERE session_id = '248d49d92b046c60ee69245c0dfc63a9'

UPDATE `ci_sessions` SET `last_activity` = 1280863060, `user_agent` = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv', `ip_address` = 'XX.XXX.XX.XXX', `session_data` = 'REMOVED FOR SECURITY}' WHERE session_id = '248d49d92b046c60ee69245c0dfc63a9'