Thread Tools
Old May 8, 2002, 10:54   #1
Ecthy
Civilization II MultiplayerApolytoners Hall of FameSpanish Civers
Emperor
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Mar 2000
Posts: 8,491
Why does editing posts take longer than posting them?
Been noticing this over and over since the upgrade to vB. What causes this? Is it the post has to be found in the tree for editing while it's just added when posted?
Ecthy is offline  
Old May 8, 2002, 11:51   #2
Lemmy
Alpha Centauri Democracy GameACDG The Cybernetic ConsciousnessACDG3 Spartans
King
 
Lemmy's Avatar
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Dec 2000
Location: Bubblewrap
Posts: 2,032
exactly..
__________________
<Kassiopeia> you don't keep the virgins in your lair at a sodomising distance from your beasts or male prisoners. If you devirginised them yourself, though, that's another story. If they devirginised each other, then, I hope you had that webcam running.
Play Bumps! No, wait, play Slings!
Lemmy is offline  
Old May 8, 2002, 12:05   #3
Gramphos
staff
Civilization III MultiplayerC4WDG Team ApolytonCivilization IV: MultiplayerAge of Nations TeamC4BtSDG Realms BeyondCivilization IV Creators
Technical Director
 
Gramphos's Avatar
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Apr 2001
Location: Chalmers, Sweden
Posts: 9,294
Well, it's always harder to write in a file then writeing at the end of a file.
__________________
ACS - Technical Director
Gramphos is offline  
Old May 8, 2002, 12:45   #4
Eli
Civ4 SP Democracy GamePtWDG Vox ControliC4DG VoxCiv4 InterSite DG: Apolyton Team
Emperor
 
Eli's Avatar
 
Local Time: 03:19
Local Date: November 1, 2010
Join Date: Jul 2000
Location: Israel
Posts: 6,480
I also noticed the "problem".
__________________
"Beware of he who would deny you access to information, for in his heart he dreams himself your master" - Commissioner Pravin Lal.
Eli is offline  
Old May 8, 2002, 13:57   #5
Dauphin
Civilization IV PBEMPolyCast Team
Deity
 
Dauphin's Avatar
 
Local Time: 01:19
Local Date: November 1, 2010
Join Date: Dec 1969
Location: Seouenaca, Cantium
Posts: 12,426
The obvious solution is to get it <strike>write, oh crap</strike> right first time.

EDIT - THAT WAS DELIBERATE

THIRD TIME LUCKY
__________________
"Everybody knows you never go full retard. You went full retard man. Never go full retard"
Dauphin is offline  
Old May 8, 2002, 14:39   #6
Ecthy
Civilization II MultiplayerApolytoners Hall of FameSpanish Civers
Emperor
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Mar 2000
Posts: 8,491
so my assumption was right. so if it's all a tree... how frequently does it get balanced?
Ecthy is offline  
Old May 8, 2002, 15:43   #7
Eli
Civ4 SP Democracy GamePtWDG Vox ControliC4DG VoxCiv4 InterSite DG: Apolyton Team
Emperor
 
Eli's Avatar
 
Local Time: 03:19
Local Date: November 1, 2010
Join Date: Jul 2000
Location: Israel
Posts: 6,480
Quote:
Originally posted by Ecthelion
so my assumption was right. so if it's all a tree... how frequently does it get balanced?
Eli is offline  
Old May 8, 2002, 15:44   #8
Lemmy
Alpha Centauri Democracy GameACDG The Cybernetic ConsciousnessACDG3 Spartans
King
 
Lemmy's Avatar
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Dec 2000
Location: Bubblewrap
Posts: 2,032
i'm not sure if it's actually a tree, i think it's just a simple database really, since it uses MySQL.
__________________
<Kassiopeia> you don't keep the virgins in your lair at a sodomising distance from your beasts or male prisoners. If you devirginised them yourself, though, that's another story. If they devirginised each other, then, I hope you had that webcam running.
Play Bumps! No, wait, play Slings!
Lemmy is offline  
Old May 8, 2002, 16:05   #9
Ecthy
Civilization II MultiplayerApolytoners Hall of FameSpanish Civers
Emperor
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Mar 2000
Posts: 8,491
And a database is not arranged as a tree? given the vast amount of posts, it must be.

I see Eli's returned to "" only posting.
Ecthy is offline  
Old May 8, 2002, 16:24   #10
Gramphos
staff
Civilization III MultiplayerC4WDG Team ApolytonCivilization IV: MultiplayerAge of Nations TeamC4BtSDG Realms BeyondCivilization IV Creators
Technical Director
 
Gramphos's Avatar
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Apr 2001
Location: Chalmers, Sweden
Posts: 9,294
Quote:
Originally posted by Ecthelion
I see Eli's returned to "" only posting.
The "-s look stange wound a smilie, (I have to test this "")

No to the actual reason for this post: Can it be the update of the searchindex that takes time (removing the post from wth words it no longer has)
__________________
ACS - Technical Director
Gramphos is offline  
Old May 8, 2002, 16:42   #11
Lemmy
Alpha Centauri Democracy GameACDG The Cybernetic ConsciousnessACDG3 Spartans
King
 
Lemmy's Avatar
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Dec 2000
Location: Bubblewrap
Posts: 2,032
lol, it seems like mysql does use a tree structure...
Then i think the search would be the extra time, cos i don't think changing data is much different than adding, you just assign the new text editted to the old post, no need to remove the old post, it just gets overriden...off course this just my speculation on how mysql works... ""
__________________
<Kassiopeia> you don't keep the virgins in your lair at a sodomising distance from your beasts or male prisoners. If you devirginised them yourself, though, that's another story. If they devirginised each other, then, I hope you had that webcam running.
Play Bumps! No, wait, play Slings!
Lemmy is offline  
Old May 8, 2002, 17:04   #12
Ecthy
Civilization II MultiplayerApolytoners Hall of FameSpanish Civers
Emperor
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Mar 2000
Posts: 8,491
just testing... and responding, of course
""
Ecthy is offline  
Old May 8, 2002, 18:42   #13
Asher
Apolytoners Hall of Fame
President of the OT
 
Asher's Avatar
 
Local Time: 18:19
Local Date: October 31, 2010
Join Date: Nov 1999
Location: Calgary, Alberta
Posts: 40,843
Pretty basic.
Editing involves locating where the original post was, deleting the original contents, then replacing those contents with the new post.

Posting involves adding more to the known end of a file.
__________________
"I'll never doubt you again when it comes to hockey, [Prince] Asher." - Guynemer
Asher is offline  
Old May 8, 2002, 22:10   #14
Skanky Burns
Alpha Centauri Democracy GameACDG The Cybernetic ConsciousnessC4DG Team Alpha CentauriansApolytoners Hall of FameACDG3 Spartans
 
Skanky Burns's Avatar
 
Local Time: 11:19
Local Date: November 1, 2010
Join Date: Aug 2001
Location: Skanky Father
Posts: 16,530
But think of the trees!! Won't someone think of the trees!!!

""
__________________
I'm building a wagon! On some other part of the internets, obviously (but not that other site).
Skanky Burns is offline  
Old May 8, 2002, 22:53   #15
Urban Ranger
NationStatesApolyton Storywriters' GuildNever Ending Stories
Deity
 
Urban Ranger's Avatar
 
Local Time: 08:19
Local Date: November 1, 2010
Join Date: May 1999
Location: The City State of Noosphere, CPA special envoy
Posts: 14,606
Are you sure it uses a balanced b-tree? Looks like too much trouble.

''
__________________
(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."
Urban Ranger is offline  
Old May 9, 2002, 00:40   #16
loinburger
Apolytoners Hall of Fame
Emperor
 
Local Time: 20:19
Local Date: October 31, 2010
Join Date: Jul 1999
Posts: 5,605
I've noticed far more "Your command has been ****ed up, please try again" errors when editing than when posting.
__________________
"For just twenty cents a day, we'll moisten your dreams with man urine." -Space Ghost
loinburger is offline  
Old May 9, 2002, 01:07   #17
Skanky Burns
Alpha Centauri Democracy GameACDG The Cybernetic ConsciousnessC4DG Team Alpha CentauriansApolytoners Hall of FameACDG3 Spartans
 
Skanky Burns's Avatar
 
Local Time: 11:19
Local Date: November 1, 2010
Join Date: Aug 2001
Location: Skanky Father
Posts: 16,530
I generally get them when voting. ""
__________________
I'm building a wagon! On some other part of the internets, obviously (but not that other site).
Skanky Burns is offline  
Old May 9, 2002, 03:38   #18
Scouse Gits
lifer
Civilization II PBEMTrade Wars / BlackNova TradersGalCiv Apolyton EmpireApolytoners Hall of FameCivilization II Succession Games
Emperor
 
Scouse Gits's Avatar
 
Local Time: 00:19
Local Date: November 1, 2010
Join Date: Nov 1999
Location: Liverpool, United Kingdom
Posts: 6,344
/me like smilies with ears "" *

and a crude timing test gives twice the time to edit than to post originally ...
__________________
"Our words are backed by empty wine bottles! - SG(2)
"One of our Scouse Gits is missing." - -Jrabbit
Scouse Gits is offline  
Old May 9, 2002, 05:31   #19
Lemmy
Alpha Centauri Democracy GameACDG The Cybernetic ConsciousnessACDG3 Spartans
King
 
Lemmy's Avatar
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Dec 2000
Location: Bubblewrap
Posts: 2,032
Quote:
Are you sure it uses a balanced b-tree? Looks like too much trouble.
yes, i searched at google, got directed to the mysql site (duh""), can't remember the url, or my exact search criteria, but i'm pretty sure...it said balanced b-tree

Quote:
''
haha, your smilie has small ears ""
__________________
<Kassiopeia> you don't keep the virgins in your lair at a sodomising distance from your beasts or male prisoners. If you devirginised them yourself, though, that's another story. If they devirginised each other, then, I hope you had that webcam running.
Play Bumps! No, wait, play Slings!
Lemmy is offline  
Old May 9, 2002, 07:06   #20
Ecthy
Civilization II MultiplayerApolytoners Hall of FameSpanish Civers
Emperor
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Mar 2000
Posts: 8,491
I created a monster ""

Guys, whenever you post a smiley with ears, remember who started it! And spell it right: Ec-the-lion ""

Anyway, I just asked if it was a balanced tree, but this morning I came to the conclusion that lists would be efficient enough. A list of forums, where each forum is a list of threads (easily sort-able and positions easily switch-able) where each thread is a list of posts. A big tree of posts would oly be useful if they were in some random order, so it's certainly not a balanced tree. The allocation with threads and forums would be too difficult.

BTW, the only lists that needs to bye really dynamic is a forum, because only threads exchange positions on the listing. But then, posts need to be removed as well.

And when I come and think about it, forums don't even need to be listed sort of dynamically, for they're in no real connection to each other. So they're just lists (forums, of threads) of lists (threads, of posts)

That's what I suppose. It seems more logical than one huge tree.
Ecthy is offline  
Old May 9, 2002, 07:11   #21
Ecthy
Civilization II MultiplayerApolytoners Hall of FameSpanish Civers
Emperor
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Mar 2000
Posts: 8,491
but that can't be it either... every time someone bumps a thread a list would have to be altered... given how long it takes to edit a post, posting as such would take lot longer... or?
Ecthy is offline  
Old May 9, 2002, 14:55   #22
Grrr
Civilization III Multiplayer
King
 
Grrr's Avatar
 
Local Time: 13:19
Local Date: October 31, 2010
Join Date: Dec 2000
Location: of Hamilton, New-Zealand.
Posts: 1,160
I almost posted a thread on this... Smilies with ears.
__________________
Grrr | Pieter Lootsma | Hamilton, NZ | grrr@orcon.net.nz
Waikato University, Hamilton.
Grrr is offline  
Old May 9, 2002, 18:37   #23
Lemmy
Alpha Centauri Democracy GameACDG The Cybernetic ConsciousnessACDG3 Spartans
King
 
Lemmy's Avatar
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Dec 2000
Location: Bubblewrap
Posts: 2,032
the way the threads are listed has nothing to do with the actual database structure, the way they are listed depends on the php-code, i odn't know MySql, but in sql there could be something like SORT BY lastpost.date, but you could also have something likwe SORT BY thread.name, then all threads would be shown by name, but the db structure would remain the same..

i wonder whast this looks like: ~~
__________________
<Kassiopeia> you don't keep the virgins in your lair at a sodomising distance from your beasts or male prisoners. If you devirginised them yourself, though, that's another story. If they devirginised each other, then, I hope you had that webcam running.
Play Bumps! No, wait, play Slings!
Lemmy is offline  
Old May 9, 2002, 23:36   #24
Urban Ranger
NationStatesApolyton Storywriters' GuildNever Ending Stories
Deity
 
Urban Ranger's Avatar
 
Local Time: 08:19
Local Date: November 1, 2010
Join Date: May 1999
Location: The City State of Noosphere, CPA special envoy
Posts: 14,606
I got to the mySQL site, can't be arsed to find the actual info though
__________________
(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."
Urban Ranger is offline  
Old May 10, 2002, 04:31   #25
Lemmy
Alpha Centauri Democracy GameACDG The Cybernetic ConsciousnessACDG3 Spartans
King
 
Lemmy's Avatar
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Dec 2000
Location: Bubblewrap
Posts: 2,032
i searched for "mysql structure tree" at google, it's the 2nd link ""
http://www.mysql.com/doc/I/n/InnoDB_...structure.html
__________________
<Kassiopeia> you don't keep the virgins in your lair at a sodomising distance from your beasts or male prisoners. If you devirginised them yourself, though, that's another story. If they devirginised each other, then, I hope you had that webcam running.
Play Bumps! No, wait, play Slings!
Lemmy is offline  
Old May 10, 2002, 06:35   #26
Ecthy
Civilization II MultiplayerApolytoners Hall of FameSpanish Civers
Emperor
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Mar 2000
Posts: 8,491
so I was right about b-trees, but I'm not convinced by the system's efficiency
Ecthy is offline  
Old May 10, 2002, 08:41   #27
Urban Ranger
NationStatesApolyton Storywriters' GuildNever Ending Stories
Deity
 
Urban Ranger's Avatar
 
Local Time: 08:19
Local Date: November 1, 2010
Join Date: May 1999
Location: The City State of Noosphere, CPA special envoy
Posts: 14,606
So the indices are stored in a b-tree. Still doesn't explain why edit takes longer, since theoretically append a new leaf node takes about the same amount of time as searching for an existing index.

Thanks Lemmy.
__________________
(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."
Urban Ranger is offline  
Old May 10, 2002, 08:44   #28
Urban Ranger
NationStatesApolyton Storywriters' GuildNever Ending Stories
Deity
 
Urban Ranger's Avatar
 
Local Time: 08:19
Local Date: November 1, 2010
Join Date: May 1999
Location: The City State of Noosphere, CPA special envoy
Posts: 14,606
Did anybody notice this bit?

Quote:
Page generated in 1.5208520 seconds (94.69% PHP - 5.31% MySQL) with 30 queries
More PHP operations might explain this.
__________________
(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."
Urban Ranger is offline  
Old May 10, 2002, 10:43   #29
Lemmy
Alpha Centauri Democracy GameACDG The Cybernetic ConsciousnessACDG3 Spartans
King
 
Lemmy's Avatar
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Dec 2000
Location: Bubblewrap
Posts: 2,032
hmm, let's test it...adding a new post...
/edit 1, this is what the bottom said:
Quote:
Page generated in 0.2170900 seconds (79.53% PHP - 20.47% MySQL) with 30 queries
6.64 seconds
/edit 2, and this is the time for editing this post:
Quote:
Page generated in 0.6924469 seconds (89.38% PHP - 10.62% MySQL) with 30 queries
6.16 seconds
__________________
<Kassiopeia> you don't keep the virgins in your lair at a sodomising distance from your beasts or male prisoners. If you devirginised them yourself, though, that's another story. If they devirginised each other, then, I hope you had that webcam running.
Play Bumps! No, wait, play Slings!
Lemmy is offline  
Old May 10, 2002, 10:58   #30
Lemmy
Alpha Centauri Democracy GameACDG The Cybernetic ConsciousnessACDG3 Spartans
King
 
Lemmy's Avatar
 
Local Time: 02:19
Local Date: November 1, 2010
Join Date: Dec 2000
Location: Bubblewrap
Posts: 2,032
10% more php when editing, generating also takes longer, but i don't think it's only because of that 10% more php, it must be a combination then, searching the tree, and php code
__________________
<Kassiopeia> you don't keep the virgins in your lair at a sodomising distance from your beasts or male prisoners. If you devirginised them yourself, though, that's another story. If they devirginised each other, then, I hope you had that webcam running.
Play Bumps! No, wait, play Slings!
Lemmy is offline  
 

Bookmarks

Thread Tools

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 On
HTML code is On

Forum Jump


All times are GMT -4. The time now is 20:19.


Design by Vjacheslav Trushkin, color scheme by ColorizeIt!.
Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Apolyton Civilization Site | Copyright © The Apolyton Team