Length of PM text

unknowngiver · 01-07-2007, 08:02 PM

Hey
i am not so gud with coming up with the Field length for databases..
how big should the length be for "message" field in PM ?
thanks

Dan · 01-07-2007, 08:09 PM

Make it a long text (which doesn't need a length.) :X

unknowngiver · 01-07-2007, 08:18 PM

o kool..same for "comments"/"Posts" right? and is 11 [int] good for id?

Dan · 01-07-2007, 08:40 PM

I always use 10 int for id's, which doesn't really matter unless you are expecting over 9,999,999 members/posts/comments/whatever.

-PS- · 01-08-2007, 05:51 AM

Originally Posted by Dan

I always use 10 int for id's, which doesn't really matter unless you are expecting over 9,999,999 members/posts/comments/whatever.

well using int(10) or int(11) isn't going to make that much of a difference if your going to use long text everywhere ?

comments and pm's are usally smallish, maybe limit there size in some way ?
????: NamePros.com http://www.namepros.com/programming/278400-resolved-length-of-pm-text.html

(if it's unlimited, it in some ways could be used a ddos against your site - what if someone posted a 1meg file over and over in pm / comment / post - it'd kill your site very quickly)

lee101 · 01-08-2007, 06:00 AM

I usually use text, but that is a good point from powerspike, although phpbb seems to be set to text, so that is limited to 65535 which seems quite large.

baxter · 01-08-2007, 07:56 AM

Originally Posted by powerspike

(if it's unlimited, it in some ways could be used a ddos against your site - what if someone posted a 1meg file over and over in pm / comment / post - it'd kill your site very quickly)

I believe on most server software the amount of data that can be sent through POST DATA is limited. I think the norm is around 2MB but don't quote me on that

????: NamePros.com http://www.namepros.com/showthread.php?t=278400

Bax

01-07-2007, 08:02 PM	THREAD STARTER #1 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 3,088	Length of PM text Hey i am not so gud with coming up with the Field length for databases.. how big should the length be for "message" field in PM ? thanks __________________ Simplifying Engineering \|\| $$ Currency Converter $$ Julsh - Community/Dating Website \|\| Free Image hosting Fresh Proxies \|\| Random Proxy \|\| Troll Board

01-07-2007, 08:18 PM	THREAD STARTER #3 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 3,088	o kool..same for "comments"/"Posts" right? and is 11 [int] good for id? __________________ Simplifying Engineering \|\| $$ Currency Converter $$ Julsh - Community/Dating Website \|\| Free Image hosting Fresh Proxies \|\| Random Proxy \|\| Troll Board Last edited by unknowngiver; 01-07-2007 at 08:26 PM.

01-08-2007, 06:00 AM	#6 (permalink)
lee101 NamePros Regular Join Date: Mar 2006 Location: United Kingdom Posts: 413 Follow @leefindlow	I usually use text, but that is a good point from powerspike, although phpbb seems to be set to text, so that is limited to 65535 which seems quite large. __________________ Linux Screenshots

01-07-2007, 08:09 PM	#2 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,796	Make it a long text (which doesn't need a length.) :X

01-07-2007, 08:40 PM	#4 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,796	I always use 10 int for id's, which doesn't really matter unless you are expecting over 9,999,999 members/posts/comments/whatever.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)