Hardcoding in PHP versus SQL

[mihai11]

Originally Posted by Marco van Herwaarden

You could consider storing the categories also as a serialised array in the datastore table. This would reduce the number of extra queries to 1 (which often can be combined with reading other datastore values).

Hmm.... it is the first time that I look at the datastore table. Can you give me more information about it ? What is its purpose ? Maybe you have a link with relevant information.

Since I am not using datastore values anywhere else in my mod there is no advantage from this point of view: I mean, I am already using just 1 query to retrieve the results.

One more question: how do I serialize values to the datastore ? Is there some VB class to do this ?

Originally Posted by EnIgMa1234

One query isn't much of a differance if there's only 10 results. I'd go with SQL but thats just me.

The problem is that the page that requires this query has many options (besides categories) and for each option I will need to fire this query. There will be many views ...

Maybe I should make the table storing this data of type MEMORY. Since it is very small there should be no problem here. Currently the storage engine is INNODB.