Re: A no brainer...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Wow... well, I was certainly not speaking from direct experience, only from
what seemed to make sense to me. This tells me that their is some serious
room for improvement in PHP de-serialization code...

   td


Sorry Tony, I should have been more clear.  I already know that
storing session data in MySQL is faster than storing it in files.  I
know that goes against what you're saying, but there are some
examples if you Google "PHP MySQL session performance".  One of the
more interesting examples is http://shiflett.org/articles/guru-speak-
jan2005.  PHP session management defaults to files because it's more
portable and the performance difference doesn't matter for small
sites with few concurrent users.  MySQL also provides better
scaleability and security for session data.

On Oct 14, 2006, at 2:51 PM, Larry Garfield wrote:
> It depends on what your data is.
>
> Is your data basic (a few elements in a linear array) or complex (a
> deeply
> nested multi-dimensional array or complex object?)  Deserializing a
> complex
> data structure can get expensive.
>
> Is your data built by a single simple query against the database, a
> single but
> very complex query with lots of joins and subqueries, or a bunch of
> separate
> queries over the course of the program?  A single SQL query for
> cached data
> is likely faster than lots of little queries.
>
> Is your data something that's going to change every few seconds,
> every few
> minutes, or every few days?  Caching something that will change by
> your next
> page request anyway is a waste of cycles.
>
> Is your data needed on every page load?  Putting a complex data
> structure into
> the session if you only need it occasionally is a waste of cycles.
> You're
> better off rebuilding it each time or implementing your own caching
> mechanism
> that only loads on demand.
>
> There is no general answer here.

Good points Larry.  I have to look back, but I think we were
originally talking about basic user data.  ie. the user logs into the
site and we store their login information and access rights in a
session.  That seems like basic enough information that it's better
to just store the user id in session data and grab the rest of their
information from the db - not much of a difference in performance,
plus you end up avoiding stale data.  Anyway, I like your distinction
between simple and complex objects.

-Ed

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




--
Publish technical articles @ skilledwords.com and get 100% of the
ad-revenue!
http://www.skilledwords.com

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux