I'm a Movable Type refugee that wants to switch away at a convenient point. WordPress seemed too inflexible for my needs, whereas S9Y seems to be just what I'm looking for.
I was looking into the database that's generated and it seemed that certain parts of it haven't been normalized. Some examples can be found in serendipity_entries - author can be retrieved via authorid, and the comments and trackback count can be counted via serendipity_comments.entry_id.
I'm sure there's a good reason for this. Could somebody explain it to poor confused me ?
The reason was just to reduce database traffic; counting the comments is an expensive operation which we did not want to perform everytime. Also having the authorname available without needing to fetch a different table is a tribute to performance.
Regards,
Garvin.
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
I have noticed that often in the real world (tm) normalization is overrated. When it comes to perfomance many database wizards I know (mostly Oracle-based developers) tend to modify the normalized tables in order to have a faster system that performs well in real life.
?