Greetings,
I have a related problem to my original mysql locking issue that I
want to see if I can optimize. I have my own session management
object that I use to manage sessions in a load balanced environment.
I feel that it could probably be optimized (and perhaps reduce my
table locking issues as well).
The code for the session object is here (expire in 2 days):
http://pastebin.ca/658639
When the sessions get high, more queries are locking the table and
slowing down the site, so I believe the issue is with in the
_write,_destory or _gc functions (garbage collection};
Our site is crawled frequently by bots, search engines, competitors,
etc, so the function check_agent tells the object to skip session
creation when certain user agents are noticed to reduce the amount of
entries into the database. This has helped a little.
Any ideas or best practices would be greatly appreciated.
Thank you.
~Chad
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
