not normalisation, but only my mean is UTF and combination it with (text,varchar) i don't how to get what result in select. good result, bad result, should i do indexing? according to len of utf8, optimisation is needed.
On Monday, September 2, 2013 7:36:28 AM UTC+4:30, gbr wrote: > > 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 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.
