Your post exceeds.....

[lawren2 Malibu Beach Barbie & A Super Moderator Find all posts View Profile Close lawren2]

There are times when resorts bulk bank. I have come across my message having too many characters several times, requiring trimming and posting in segments.

ie. http://www.timeshareforums.com/forum...ARY-2013-is-in

[Quarterbore Super Moderator Find all posts View Profile Close Quarterbore]

This is a bit of a complicated fix... The database itself sets aside so much space for our posts in these threads. The setting is used to define how much space a post could need and if we set this really high then the database saves this much space even if it is not used. This causes teh database to be really huge...

I need to look at the database tables and see what the character limit is for the posts table. If I can make it larger without making the database bigger I will do so. If however when I moved to this new board the database size for the post limit was decreased, can I leave it like this? Leaving it smaller will make teh entire site run faster plus it can help reduce the size of what is really becoming a very huge database.

I welcome feedback but I prefer to not bloat the database if we don't have too... also, was this a problem before? If it wasn't then the way I did this upgrade did help fix a few issues even if it seems to be causing you issues in the process.

[lawren2 Malibu Beach Barbie & A Super Moderator Find all posts View Profile Close lawren2]

I can live with it.

[Quarterbore Super Moderator Find all posts View Profile Close Quarterbore]

Like I said, I will go into the database tables and see what the limit for the table is and if I can increase it without making the database bigger I will do so. If not, well then unless it becomes a problem I am going to try to leave it alone. I will post here one way or the other.

[ArtsieAng Super Moderator Find all posts View Profile Close ArtsieAng]

Hmmm, I'm sure to have the same problem at some point.....Never had that problem in the past.

I understand your point about the size of the database, as well as the site running faster. I guess we could split up the post if absolutely necessary. Wouldn't that still increase the size of the database, tho?

[Quarterbore Super Moderator Find all posts View Profile Close Quarterbore]

The way a SQL database works is it saves space for the various entries based on how large the entries could be. So, if you make a table for say "POSTS" that are huge, then the entire table for these POSTS has that "posts" field set large to allow for the few huge posts. That causes the entire table to become big where if you split a long post into 2 or even 3 seperate posts it does not make all the rest of the posts in the database require so much space.

There are a few exceptions but following is the various options in the database...

CHAR( )	A fixed section from 0 to 255 characters long.
VARCHAR( )	A variable section from 0 to 255 characters long.
TINYTEXT	A string with a maximum length of 255 characters.
TEXT	A string with a maximum length of 65535 characters.
BLOB	A string with a maximum length of 65535 characters.
MEDIUMTEXT	A string with a maximum length of 16777215 characters.
MEDIUMBLOB	A string with a maximum length of 16777215 characters.
LONGTEXT	A string with a maximum length of 4294967295 characters.
LONGBLOB	A string with a maximum length of 4294967295 characters.

That is what I need to verify, are we a BLOB or TEXT and then tiny, medium, or long BLOBs or TEXTs The size of these can vary too and that is what affects the size of the database we all depend on.

NOTE: BLOB stands for Binary Large OBject. Both TEXT and BLOB are variable length types that store large amounts of data. They are similar to a larger version of VARCHAR. These types can store a large piece of data information, but they are also processed much slower.

[ArtsieAng Super Moderator Find all posts View Profile Close ArtsieAng]

OK, I understand. I can split a bulk banking if need be, no problem.

[bigfrank Administrator Find all posts View Profile Close bigfrank]

Does Mickey or Donald count as a Character?

[gandalf252002 Senior Member Find all posts View Profile Close gandalf252002]

I would imagine this has already been considered, but is it possible to have different settings for different groups? Or are these settings in the database applicable accross the board?

[Quarterbore Super Moderator Find all posts View Profile Close Quarterbore]

These settings affect all posts regardless of user, user group, or forum.

[bigfrank Administrator Find all posts View Profile Close bigfrank]

These settings affect all posts regardless of user, user group, or forum.

Can it be changed for site Contributors and Moderators?

[Quarterbore Super Moderator Find all posts View Profile Close Quarterbore]

Read my lips. NO