What compensates more? a huge field or fields the size of

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc

Poston Tue, 24 Apr 2007 3:06 pm

What compensates mai? a large field with 255 of space for example or a field of given size that will treat?
Location: Cachoeira Paulista-SP

Poston Tue, 24 Apr 2007 3:56 pm

The ideal is to have the fields in the size that will be used.
Have cases that waste bytes doesn't make a difference but in most cases, where the hardware already ta working overloaded, not worth making things worse.

Of course a field SUPERVISION must allow enough space, but a field UF has no reason to have a large space.
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?

Poston Tue, 24 Apr 2007 4:21 pm

vlw cara
Location: Cachoeira Paulista-SP

Poston Fri, 27 Apr 2007 1:49 pm

I imagine that this doubt is about the characters.

If that's right, you can use the type varchar2, which stores only o que will use indeed.
Location: Criciúma - SC

Poston Fri, 27 Apr 2007 1:50 pm

If Oracle varchar2, but in cases of other banks, you can search for varchar, because the more well known and have a decent type ' varchar '.
Location: Criciúma - SC

Return to SQL

Who is online

Users browsing this forum: No registered users and 5 guests