[Ilugc] mysql optimization
- From: venkat83@xxxxxxxxx (Venkatraman S)
- Date: Thu Jul 15 21:44:38 2010
On Thu, Jul 15, 2010 at 9:30 PM, Deepan Chakravarthy <codeshepherd@xxxxxxxxx
wrote:
I need some help in creating the best possible table schema for the
following condition.
My Try:
#Users - username,userid
#Groups - groupname,groupid
#Usergroups - userid,groupid
#GroupQs - groupid, groupQid,groupQQuestion
#UserAnss - userid, groupQid, userAnswer
Where Users,Groups,Usergroups,GroupQs ,UserAnss are the tables and the comma
separated list in front of the table name is the columns.
As for the queries, if you are using django-orm(or any other ORM) then it
should be pretty easy.
-V-
http://twitter.com/venkasub
Other related posts: