On Sat, Jun 18, 2011 at 2:06 AM, AJ <[email protected]> wrote: > Thanks Himesh for replying.. > excatly this came to my mind also and i also setup the foreign key > relationship of user_imag_table with both other tables(along with > cascade on delete and update).. > but problem with this approach is that if u got a lakh images and a > lakh user total no combinations is lakh-square and thts really very > large in terms of memory and efficiency of searching.. also it has > redundancy.. >
Apply decomposition operation to get this problem solved. ( Anyone good in relational algebra can do it. ) -- With Regards, Gaurav Paliwal http://gauravpaliwal.com -- Mailing list guidelines and other related articles: http://lug-iitd.org/Footer
