08-05-2002 19:54									#1
	Why does editing posts take longer than posting them? Support Apolyton buy from Amazon

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?

	08-05-2002 20:51									#2
	Help yourself to an AD-FREE life

exactly..

	08-05-2002 21:05									#3
	Full PM-box? Change here!

Well, it's always harder to write in a file then writeing at the end of a file.

	08-05-2002 21:45									#4
	Help yourself to an AD-FREE life

I also noticed the "problem".

	08-05-2002 22:57									#5
	Support Apolyton, buy GURPS/ Alpha Centauri

The obvious solution is to get it <strike>write, oh crap</strike> right first time.

EDIT - THAT WAS DELIBERATE

THIRD TIME LUCKY

	08-05-2002 23:39									#6
	Support Apolyton buy from Amazon

so my assumption was right. so if it's all a tree... how frequently does it get balanced?

	09-05-2002 00:43									#7
	Support Apolyton, buy Alpha Centauri

quote: Originally posted by Ecthelion so my assumption was right. so if it's all a tree... how frequently does it get balanced?

	09-05-2002 00:44									#8
	Support Apolyton, buy Alpha Centauri

i'm not sure if it's actually a tree, i think it's just a simple database really, since it uses MySQL.

	09-05-2002 01:05									#9
	Support Apolyton, buy Civilization 2

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.

	09-05-2002 01:24									#10
	Increase the size of your Attachments

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)

	09-05-2002 01:42									#11
	Support Apolyton or Terrorists Win

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... ""

	09-05-2002 02:04									#12
	just testing... and responding, of course Support Apolyton or Terrorists Win

""

	09-05-2002 03:42									#13
	Support Apolyton, buy GURPS/ Alpha Centauri

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.

	09-05-2002 07:10									#14
	Support Apolyton, buy GURPS/ Alpha Centauri

But think of the trees!! Won't someone think of the trees!!!

""

	09-05-2002 07:53									#15
	Support Apolyton, pre-order Civilization IV

Are you sure it uses a balanced b-tree? Looks like too much trouble.

''

	09-05-2002 09:40									#16
	Suffering from ads?

I've noticed far more "Your command has been ****ed up, please try again" errors when editing than when posting.

	09-05-2002 10:07									#17
	Support Apolyton, buy Galactic Civilizations

I generally get them when voting. ""

	09-05-2002 12:38									#18
	Support Apolyton, buy Civilization 2

* Scouse Gits like smilies with ears "" *

and a crude timing test gives twice the time to edit than to post originally ...

	09-05-2002 14:31									#19
	Support Apolyton buy from Amazon

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 ""

	09-05-2002 16:06									#20
	Support Apolyton, buy Call to Power 2

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.

	09-05-2002 16:11									#21
	Avatar Enlargement: We've got the solution

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?

	09-05-2002 23:55									#22
	Full PM-box? Change here!

I almost posted a thread on this... Smilies with ears.

	10-05-2002 03:37									#23
	Support Apolyton, pre-order Civilization IV

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: ~~

	10-05-2002 08:36									#24
	Tired of ads?

I got to the mySQL site, can't be arsed to find the actual info though

	10-05-2002 13:31									#25
	Increase the size of your Attachments

i searched for "mysql structure tree" at google, it's the 2nd link ""
http://www.mysql.com/doc/I/n/InnoDB..._structure.html

	10-05-2002 15:35									#26
	Support Apolyton buy from Amazon

so I was right about b-trees, but I'm not convinced by the system's efficiency

	10-05-2002 17:41									#27
	Support Apolyton, buy Call to Power 2

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.

	10-05-2002 17:44									#28
	Full PM-box? Change here!

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.

	10-05-2002 19:43									#29
	Support Apolyton

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

	10-05-2002 19:58									#30
	Help yourself to an AD-FREE life

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