Increase maximum characters if signature?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24377
Printed Date: 06 April 2026 at 3:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Increase maximum characters if signature?
Posted By: levis
Subject: Increase maximum characters if signature?
Date Posted: 10 September 2007 at 5:25am
The maximum characters of signature at 200 is a bit little. How can i increase it?
Thanks!
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 10 September 2007 at 9:26am
The reason for this limit is because many databases have a 255 character limit on some database types, and BBcodes increase the size of your signature.
Using a different datatype to hold more data reduces performance and increases server load due to the underlying way DBMS's work.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: billd3
Date Posted: 10 September 2007 at 3:05pm
great answer, boRg, however, let's say that we run SQL, and will probably always run SQL, is there a limit in MS SQL 2005 or later, and if not, is there a way to manually increase that limit with a file edit, knowing what we are doing on our own forum?
I understand your default limit and it's probably wise, but what about an individual?
Does SQL have such a limit with that sort of field?
-------------
BillD
http://theamcpages.com
http://theamcforum.com
|
Posted By: WebWiz-Bruce
Date Posted: 10 September 2007 at 4:06pm
No it's not just Access this effects. Larger field types should always be avoided where possiable.
If you do some searching on Google there is lots of papers on DBMS performance.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
|