Really I can see why Drupal does it this way - having it stored and called each time one of your comments comes up is another database call - it's more efficient to just populate it in your comments...
Hm. Yes, but ... it's also using up more hard drive space by repeating the exact same information in so many different records, rather than just appending it from the stored user profile when the comment is called up ... interesting decision they made.
For comments I guess the tilt is towards reducing the db call since the stuff stored is pretty small while on the avatar it's stored separately and requires a call (I'm guessing because image files are larger.)
It's not only a time/disk-space tradeoff, I expect. Embedding the signature in the comment means that if somebody changes his/her signature, it WILL NOT change in already-posted messages. Pulling the sig from a DB would show the most recent signature regardless of when the message was posted.
I don't get what you're asking. Your signature shows up in your comments, right? At least it's supposed to - it pops up in the actual comment box when you're filling it out.
Yeah, that's what I mean.
by The William G - 03/14/2006 - 00:57
Yeah, that's what I mean. It's part of the body of the text. Here it is:
The William G - Romantic Drama, Post-Apocalyptic Monsters, and More Comic Experimentation
So if I type below it, it's not really a sig anymore.
I guess I'm just used to it being added as a sort of footer automatically in BBcode.
Just the way this code works
by Xaviar Xerexes - 04/06/2006 - 21:29
Really I can see why Drupal does it this way - having it stored and called each time one of your comments comes up is another database call - it's more efficient to just populate it in your comments...
____
Xaviar Xerexes
I am a Modern Major Generality.
I run this place! Tip the piano player on the way out.
Hm. Yes, but ... it's also
by Joey Manley - 04/06/2006 - 23:55
Hm. Yes, but ... it's also using up more hard drive space by repeating the exact same information in so many different records, rather than just appending it from the stored user profile when the comment is called up ... interesting decision they made.
Joey
www.webcomicsnation.com
That is the trade-off
by Xaviar Xerexes - 04/07/2006 - 08:58
For comments I guess the tilt is towards reducing the db call since the stuff stored is pretty small while on the avatar it's stored separately and requires a call (I'm guessing because image files are larger.)
____
Xaviar Xerexes
I am a Modern Major Generality.
I run this place! Tip the piano player on the way out.
And changeability
by LineItemVito - 04/07/2006 - 10:27
It's not only a time/disk-space tradeoff, I expect. Embedding the signature in the comment means that if somebody changes his/her signature, it WILL NOT change in already-posted messages. Pulling the sig from a DB would show the most recent signature regardless of when the message was posted.
Eddie
--
Vote Vito: Line Item Vito
--
Vote Vito: Line Item Vito
That's not normal.
by Fabricari - 04/07/2006 - 00:42
That's not normal. Denormalized even.
Bwah hah hah *ahem*
Geek humor. I should do webcomics.
Fabricari - Sexy Robots and Violent Cyberpunk Comics
Steve "Fabricari" Harrison
Don't Understand
by Xaviar Xerexes - 03/13/2006 - 21:50
I don't get what you're asking. Your signature shows up in your comments, right? At least it's supposed to - it pops up in the actual comment box when you're filling it out.
____
Xaviar Xerexes
I am a Modern Major Generality.
I run this place! Tip the piano player on the way out.