Tony Marston wrote:
"Sancar Saran" <sancar.saran@xxxxxxxxxx> wrote in message
news:200703050015.50252.sancar.saran@xxxxxxxxxxxxx
On Sunday 04 March 2007 23:04, Sancar Saran wrote:
Hi,
I want to know is there any db server around there for store php arrays
natively.
Regards
Sancar
Thanks for responses, it seems I have to give more info about situation.
In my current project, we had tons of arrays. They are very deep and
unpredictable nested arrays.
Currently we are using serialize/unserialize and it seems it comes
with own
cpu cost. Xdebug shows some serializing cost blips. Sure it was not
SO BIG
deal (for now of course).
My db expertise covers a bit mysql and mysql does not have any array
type
field (enum just so simple).
Wrong! Take a look at the SET datatype
http://dev.mysql.com/doc/refman/4.1/en/set.html. This allows you to
have an array of values in a single field, and the user can select any
number of them.
It might be worth looking at wddx. I can't speak about the cpu cost for
large numbers of arrays, but it's mechanism is simple. It saves data
types as XML strings, which can be written using
**wddx_serialize_vars()* <cid:part1.05070903.01090402@shaw.ca> *and read
using **wddx_deserialize()* <cid:part2.08060209.04020008@shaw.ca>.
--
_____________________
Myron Turner
http://www.room535.org
http://www.bstatzero.org
http://www.mturner.org/XML_PullParser/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
