@AJ
You will need three tables atleast, simplest way. Lets say
img_tbl, usr_tbl, usr_img_tbl
The img_tbl will have two fields the img_id( Primary key) , and
second img_url.
The usr_tbl, usr_id(Primary key), usr_name.
The usr_img_tbl will have the primary keys of both the other
tables as fields, thus creating the relationship, usr_id, img_id.
Now all comes up to how you create the indexes on your tables,
I would suggest you create indexes for the id fields on tables img_tbl
and usr_tbl, and create 2 unique index using both the fields for
usr_img_tbl, inter changing the order of the fileds in each.
Hope this helps.
Thanks
Himesh.
On Jun 17, 3:21 pm, AJ <[email protected]> wrote:
> help needed on
> this:http://stackoverflow.com/questions/6384320/optimised-database-archite...
--
Mailing list guidelines and other related articles: http://lug-iitd.org/Footer
