Question about triming [code] blocks

schickel · 2009-03-29, 08:03

If a message with a large [code] block is edited to trim the size of the block, does that remove the block from the message DB, or does the entire message have to be deleted?

(I'm working on figuring out the best way to trim some of the messages in our forum....)

Xyzzy · 2009-03-30, 04:29

Compressed attachments are best. Anything that is not an attachment is in the database.

mdettweiler · 2009-03-30, 05:10

Quote:

Originally Posted by Xyzzy

Compressed attachments are best. Anything that is not an attachment is in the database.

But, I think what schickel was asking is, if you retroactively delete a large amount of text from an already-existing post, does it actually get deleted from the database? Or does it, indeed, get left in place because the DB is still storing it in the edit log?

schickel · 2009-03-30, 06:08

Quote:

Originally Posted by mdettweiler

But, I think what schickel was asking is, if you retroactively delete a large amount of text from an already-existing post, does it actually get deleted from the database? Or does it, indeed, get left in place because the DB is still storing it in the edit log?

Yeah, what he said.....

Xyzzy · 2009-04-01, 03:27

The posts get cleaned up when the database tables are optimized, which happens every now and then.

2009-03-29, 08:03	#1
schickel "Frank <^>" Dec 2004 CDP Janesville 4112₈ Posts	Question about triming [code] blocks If a message with a large [code] block is edited to trim the size of the block, does that remove the block from the message DB, or does the entire message have to be deleted? (I'm working on figuring out the best way to trim some of the messages in our forum....)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Transporting Large Stone Blocks	a1call	Lounge	6	2017-11-02 18:58
Odd perfect related road blocks II	jchein1	Factoring	632	2011-11-14 15:14
Odd perfect related road blocks	jchein1	Factoring	31	2009-04-29 15:18
MonoDevelop vs. Code::Blocks	ixfd64	Software	1	2008-03-10 08:30
Question about factoring code	Peter Nelson	Software	9	2005-03-30 18:28

2009-03-30, 04:29	#2
Xyzzy "Mike" Aug 2002 2⁵×257 Posts	Compressed attachments are best. Anything that is not an attachment is in the database.

2009-04-01, 03:27	#5
Xyzzy "Mike" Aug 2002 8224₁₀ Posts	The posts get cleaned up when the database tables are optimized, which happens every now and then.