Re: array field type

Tony Marston wrote:

"Sancar Saran" <sancar.saran@evodot.com> wrote in message news:200703050015.50252.sancar.saran@evodot.com...

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/