03-01-2004 23:57									#1
	How come edits take longer to load than new posts? Support Apolyton, buy Galactic Civilizations

Just curious. It generally takes me three times as long as a new post to edit. The loading time from the edit post screen to that little intermediary screen is so long that it is actually more efficient to press back and refresh after I submit.

	04-01-2004 00:07									#2
	Avatar Enlargement: We've got the solution

quote: that it is actually more efficient to press back and refresh after I submit.

That's what I always do

	04-01-2004 02:31									#3
	Support Apolyton, buy Civilization III: Complete

I've always wondered about this too. Is it just the page refresh that is taking so long?

-edit-

Yup.

	04-01-2004 02:45									#4
	Support Apolyton buy from Amazon

Edits require more queries that take longer.

For new posts it just adds an entry at the end of the table, for editing posts it needs to search for the old entry in the table, then change it.

	04-01-2004 02:57									#5
	Support Apolyton, buy Civilization III: Complete

I asked before, stated my theory and it was correct.

	04-01-2004 08:43									#6
	Increase the size of your Attachments

i never edit my posts - they're always the Absolute Truth (TM).

	04-01-2004 13:19									#7
	Browse Apolyton AD-FREE

quote: Originally posted by Asher Edits require more queries that take longer. For new posts it just adds an entry at the end of the table, for editing posts it needs to search for the old entry in the table, then change it.

No it doesn't. Because it has already serached and found the entry it needed. It's just an UPDATE query.

	04-01-2004 13:38									#8
	Support Apolyton, buy GURPS/ Alpha Centauri

it's not a single update query in the posts table. there are more queries having to do with the search index which must kept updated

	04-01-2004 14:40									#9
	Suffering from ads?

quote: Originally posted by Urban Ranger No it doesn't. Because it has already serached and found the entry it needed. It's just an UPDATE query.

When will you learn enough to not argue with me when it comes to computers?

	04-01-2004 19:46									#10
	Support Apolyton, buy Galactic Civilizations: Deluxe Edition

BTW Markos, it seems that delete queries on post database don't remove the posts from search index...

	04-01-2004 22:12									#11
	Lose 30 kilos (of popups)

Let's imagine that you have a stack of 10 books. "A" is at the bottom, then B, C, D, E, F, G, H, I, "J". Now, you add book "K" to the top of the stack.

You remember an inaccuracy in book F. You must get out F and correct the mistake. To do so, you have to carefully slide out F from the stack (or take the top half of the stack off), then change it, then carefully put it back in where it was. That takes more work than just adding a book to the top, doesn't it?

	05-01-2004 08:21									#12
	Tired of ads?

quote: Originally posted by MarkG it's not a single update query in the posts table. there are more queries having to do with the search index which must kept updated

But don't you need to create those entries in the first place?

	05-01-2004 08:22									#13
	Enter the AD-FREE zone

quote: Originally posted by mrmitchell You remember an inaccuracy in book F. You must get out F and correct the mistake. To do so, you have to carefully slide out F from the stack (or take the top half of the stack off), then change it, then carefully put it back in where it was. That takes more work than just adding a book to the top, doesn't it?

Yes, but only for a stack of books

	05-01-2004 12:08									#14
	Get a bigger avatar today!

quote: Originally posted by Urban Ranger But don't you need to create those entries in the first place?

They are created, but now they have to be deleted, and new have to be created. All words longer than four(?) chatracters have to be linked to the postid, and if it is a new word it has to be added to the word table.

	05-01-2004 12:21									#15
	Inflate your Upload Space

I see, thanks

	05-01-2004 12:30									#16
	Full PM-box? Change here!

For goodness' sake, people. Edits take longer to load because the CIA, FBI, Echelon and God knows how many other of the planet's intelligence agencies are comparing your edited post to the original one and making changes to your personnel file accordingly.

Gatekeeper

	05-01-2004 23:15									#17
	Support Apolyton buy from Amazon

quote: Originally posted by Gatekeeper For goodness' sake, people. Edits take longer to load because the CIA, FBI, Echelon and God knows how many other of the planet's intelligence agencies are comparing your edited post to the original one and making changes to your personnel file accordingly. Gatekeeper

Gramphos's answer seems best.

	06-01-2004 03:32									#18
	Support Apolyton buy from Amazon

Asked, answered, spammed, TOAST.