Re: [PHP] A no brainer...


Of course, the cost of serialization and deserialization is non- trivial for
any data structure that is of interesting size, and you have to keep in mind
that if you aren't syncing to the database periodically then you will end up
with stale data objects. (An issue in any case, but the longer the object
representing a view of your database exists, the more of a problem it
becomes. YMMV depending on the data you're holding.)

Has anyone done tests on the difference between the value and performance of serializing data structures versus just pulling the data from the database?

PHP stores session data in files by default. There's gotta be a performance hit for the file access. If you store session data in MySQL, you're still making a DB query. It seems to me that the performance is almost the same, which means grabbing the current record ends up better because you avoid stale data. What do you think?

-Ed
.

Relevant Pages

  • Re: [PHP] A no brainer...
    ... any data structure that is of interesting size, ... representing a view of your database exists, the more of a problem it ... PHP stores session data in files by default. ... you're still making a DB query. ...
    (php.general)
  • Re: CBO influences
    ... > databases from 8i to 9i, and so have several copies of this database ... > generating an access plan that featured several hash joins, ... Initialization parms idendtical, data structure and volume ...
    (comp.databases.oracle.server)
  • Re: Design issues
    ... Thanks for your suggestions on naming the fields. ... I wanted some help and advise on my existing database table structure and ... normalize your data structure, I'd question how a ProjectNo or a PONo ...
    (microsoft.public.access.tablesdbdesign)
  • Re: ID field as logical address
    ... and it's caused by failure to fully normalise the data structure. ... What would the data structure look like if it were fully normalized? ... Adding an ID field does at least allow the database to record the fact that two different people with the same name and phone number exist. ... Adding an ID field is only useful if you can reliably link the ID to the real person. ...
    (comp.databases.theory)
  • Re: The agony of building an Application
    ... There are 2 ways to build a database: ... having the a normalized data structure. ... database needs to provide, what data needs be stored, and what reports need ... While writing the spec and building the tables, ...
    (microsoft.public.access.modulesdaovba)