[Falcon.]

currently i have 70 columns in table "accounts" with:
'connected', 'money', 'level', 'bank-money'... and I have to add even more, probably 50

when the player do login, i load all accounts table "select * from accounts where nickname=maria", 30 percent of columns are not used at this time.

the point is, sometimes I have to list all accounts "select x, y, z from contas where value=1"
probably the result is 170+ accounts


exemple:

select A,B,C,D,E,F,G,H from table Vince (with 100 columns)

or

select A,B,C,D from table Vince (with 50 columns)
select E,F,G,H from table Falcon (with 50 columns)

what i really wanna know is, which of the two gets more performance =/