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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.