Uros Gruber wrote:
> Hello!
>
> I just made some speed tests getting configuration from DB.
>
> For now I figured 2 ways doing this.
>
> 1. One value in each row
>
> id | name | val
> ----------------------
> 1 | name1 | value1
> ........
>
> 2. using serialize($config) and saving this in one row.
> $config is predefined array of configuration.
>
>
> I test this with 100 config values. First I read all 100 rows for 1st
> example, then I read only one row and then unserialize this to get
> array.
>
> Here is result:
>
> 1st example 0.0478450059891 86.74%
> 2nd example 0.0073139667511 13.26%
>
> There you can see speed of second example. I wan't to know what do you
> think about this. And what's your solutions of reading config from DB.
> I saw that many big project still use first example.
>
Question: How many people selected 'blue' for their config color?

1. SELECT COUNT(*) FROM Table WHERE config_color = 'blue';

2. ?? SELECT COUNT(*) FROM Table WHERE serialized_column LIKE
'"config_color";s:4:"blue";'

Basically, method 1 is more flexible. With method 2, you'll need to
store it in a TEXT column or hope your serialized value never goes over
255 characters.

--
---John Holmes...

Amazon Wishlist: [url]www.amazon.com/o/registry/3BEXC84AB3A5E/[/url]

PHP|Architect: A magazine for PHP Professionals – [url]www.phparch.com[/url]