Posted by Edward Z. Yang on 05/23/07 22:05

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

webcm123@gmail.com wrote:
> I'm making some changes in poll module. I don't know which method of
> storing options of poll is better. The main data of polls are in POLLS
> table. [snip]

Serialize and unserialize are extremely fast, so if you don't mind
breaking the rules of database normalization and stuff multiple values
in one column, your second option will be faster.

- --
Edward Z. Yang GnuPG: 0x869C48DA
HTML Purifier <htmlpurifier.org> Anti-XSS HTML Filter
[[ 3FA8 E9A9 7385 B691 A6FC B3CB A933 BE7D 869C 48DA ]]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGVLrBqTO+fYacSNoRApCIAJoCBo/NrAAkgpOl68xxV+L4Tm5onQCeOYWb
kNEGzWnAzf/Jjg2eSVE5A6A=
=I5+3
-----END PGP SIGNATURE-----

• Next in forum: Re: Protecting 'contact us' emailing forms
• Prev in forum: Re: how to identify Letter v Number in string
• Thread view: Re: Poll's options - two queries to MySQL or Unserialize()?

[Reply to this message]