Re: Is PDO incompatible with caching mechanismes like APC?

Gilles Ganault wrote:
Hi

APC doesn't like it when I store the output of a SELECT:

<snip>

Does it mean that PDO won't work with APC, and I should look at
another caching tool?

Thank you.

Before an object is stored it has to be serialized. Generally, internal classes (like PDOStatement) cannot be serialized.

It seems like what you want to do is store an array of the rows, which is perfectly possible. Just use $dbh->query(...)->fetchAll() or something similar. The query() method returns a PDOStatement object - while it can be iterated using foreach (thanks to SPL) it is not an array and cannot be serialized.

Jeremy
.

Relevant Pages

  • Re: Finding the nearest match without reusing results
    ... comparing an array with a value generates an array of Trues and ... Any diff with wrong State or with used Store is implicitly zeroed out. ... Each must be larger than the absolute value of the maximum Sales ... go.....it just needs to return the closest match. ...
    (microsoft.public.excel.programming)
  • Re: read keyboard input and storing in an array?
    ... > I'm trying to store user input in an array, ... You have the beginnings of that logic already since your prompt tells the ... 201st value since the array only has room for 200 values. ... This will force you to store the int values as Integer ('Integer' ...
    (comp.lang.java.help)
  • Re: Challenge: reading ascii data
    ... to store all the data before producing any output. ... would be bad practice in terms of memory consumption to use a standard ... So I use hashes to create a two-level "sparse array", ... Well the original problem definition was: ...
    (comp.lang.fortran)
  • Re: attempting an actual game...
    ... >>> and inflexible by the absurd decision to use a bit array for square ... as then one has 8 bits in which to store a color and a few flags ... Using a 2D int (or, ... > Change direction and you may eventually complete a game. ...
    (comp.games.development.programming.misc)
  • Re: Sparse arrays
    ... >access array element, set it, sit for a bit, and read it back ... ONLY operations are STORE and RETRIEVE with no structure to the ... If you can tolerate a bit of inefficiency ... They live in sorted lists. ...
    (comp.lang.fortran)