Dear all,
I have the following Table:
////////////////////////////
sellers = Table('sellers', MetaData(),
Column('id', Integer, primary_key=True, autoincrement = True),
Column('name', String, nullable=False),
Column('name_type', String, nullable=False),
Column('addresses', String, nullable=False),
Column('telephones', DateTime, nullable=False),
Column('emails', Integer, nullable=False),
Column('job_background', Integer, nullable=False),
Column('agent_first_name', String, nullable=False),
Column('agent_last_name', String, nullable=False),
Column('agent_attributes', String, nullable=False),
Column('agent_values', String, nullable=False),
)
////////////////////////////
Of course i created it in mysql such as:
///////////////////////////////////
id :
int 11
name :
varchar(200)utf8_persian_ciname_type:
tinyint 4
addresses:
text
utf8_persian_citelephones:
textutf8_persian_ciemails:
varchar(60)utf8_persian_cijob_background:
varchar(200)utf8_persian_ci
agent_fist_name:
varchar(200)utf8_persian_ciagent_last_name:
varchar(200)utf8_persian_ci
agent_attributes:
text
utf8_persian_ciagent_values:
text
utf8_persian_ci
//////////////////////////////////
Question: how can i optimize my table?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.