Increase maximum characters if signature?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
levis Members Profile Find Members Posts Newbie Joined: 02 August 2007 Status: Offline Points: 9	Post Options Post Reply Quote levis Report Post Thanks(0) Quote Reply Topic: Increase maximum characters if signature? Posted: 10 September 2007 at 5:25am
	The maximum characters of signature at 200 is a bit little. How can i increase it? Thanks!

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

billd3 Members Profile Find Members Posts Senior Member Joined: 19 February 2003 Location: United States Status: Offline Points: 530	Post Options Post Reply Quote billd3 Report Post Thanks(0) Quote Reply 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.