What do you mean by "optimize"? What's the desired goal of your optimisation, or in other words: what's not optimal at the moment?
Looking at your table, I can think of (guess) a few things I'd do different (namely normalisation <http://en.wikipedia.org/wiki/Database_normalization>). But whether this is more "optimal" for you or not depends on your use case... On Monday, September 2, 2013 9:22:36 AM UTC+10, Mohsen Pahlevanzadeh wrote: > > 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.
