LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices


Reply
  Search this Thread
Old 07-08-2003, 11:32 PM   #1
BajaNick
Senior Member
 
Registered: Jul 2003
Location: So. Cal.
Distribution: Slack 11
Posts: 1,737

Rep: Reputation: 46
Retroactive Signatures?


I noticed soemthing kinda near or wierd. When you change your signature on this form it is retroactive, I changed it a bunch of times and went and checked my older posts and they had the new signature.
 
Old 07-08-2003, 11:56 PM   #2
moses
Senior Member
 
Registered: Sep 2002
Location: Arizona, US, Earth
Distribution: Slackware, (Non-Linux: Solaris 7,8,9; OSX; BeOS)
Posts: 1,152

Rep: Reputation: 50
Yeah, I'm guessing the user manager is a MySQL database, which is queried every time a thread is viewed. So, when you change something, it is "retroactive" in the sense that the old posts just show whatever the profile is in the database. Saves a ton of space, but probably requires quite a powerful machine to run the SQL database what with so many posts every day.
 
Old 07-09-2003, 12:48 AM   #3
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
Quote:
Originally posted by moses
Yeah, I'm guessing the user manager is a MySQL database, which is queried every time a thread is viewed. So, when you change something, it is "retroactive" in the sense that the old posts just show whatever the profile is in the database. Saves a ton of space, but probably requires quite a powerful machine to run the SQL database what with so many posts every day.
Until the new machine that was donated, I do believe this site was running on a dual Pentium Pro 180mhz... can't remember exactly, but yes, the new server is much more powerful.
 
Old 07-09-2003, 01:13 AM   #4
moses
Senior Member
 
Registered: Sep 2002
Location: Arizona, US, Earth
Distribution: Slackware, (Non-Linux: Solaris 7,8,9; OSX; BeOS)
Posts: 1,152

Rep: Reputation: 50
I'm sure it has been posted elsewhere, and maybe is a static page on the site, but do you know the stats of the server?
 
Old 07-10-2003, 02:11 PM   #5
cli_man
Member
 
Registered: Apr 2002
Location: New York, USA
Distribution: Redhat 7.2, 9.0 Slackware 9.1
Posts: 428

Rep: Reputation: 30
Actually pulling your sig out of the database so it has the newest one does not take any more cpu than keeping the old and as said before it takes less space.

The stats page would be neat to see, I would like to know how big the database for this site is :-)
 
Old 07-10-2003, 05:18 PM   #6
cuckoopint
Member
 
Registered: Feb 2003
Distribution: Debian
Posts: 797

Rep: Reputation: 30
Text takes up a lot of space these days. Lots of posts.
; )

But yeah, it shouldn't require much more CPU power. Also, sometimes when googling you hit a LQ archive - it has the posts, but it does not have all the fancy stuff about the users (the stuff on the left) and it does not have sigs.
 
Old 07-10-2003, 05:39 PM   #7
cli_man
Member
 
Registered: Apr 2002
Location: New York, USA
Distribution: Redhat 7.2, 9.0 Slackware 9.1
Posts: 428

Rep: Reputation: 30
Yeah I have found that a few times part of the archive it looks like, (not a mod so I don't really know just guessing :-)
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
bad signatures dolphans1 Mandriva 8 11-25-2005 12:38 PM
bad signatures OrganicOrange84 Linux - Newbie 1 09-04-2004 12:14 AM
bad signatures ed_norton Linux - Newbie 5 04-14-2004 03:06 AM
file Signatures ? juanb Linux - Newbie 2 03-19-2004 03:10 PM
Bad Signatures basttrax Linux - Newbie 9 02-12-2004 06:13 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > General

All times are GMT -5. The time now is 11:45 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration