Timasmith wrote:
Suppose I have a database table with 20 fields which are lookups to a
single table.
configtable(configtable_id, a_field, something_lookup_id,
another_lookup_id, ...)
lookup(lookup_id, value, description, ...)
what is going to be faster to map the rows to an Object which needs
the 'value' for every field ending in lookup_id
[snip]
b) Cache all lookup values and populate
It seems that the latter *might* be better to scale outward better,
as
you could add application servers to do the caching/mapping and you
only select from a single table?
It *might* scale better and be faster. It might not. The only way to
know is to test it. When you do compare, don't forget to allow for
handling changes to the lookup table in the database.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
