Hi all, We are currently designing a database for our application (python/mysql) and we have some performance concern:
We would have "users" and "images". "users" can view some "images". "images" can be viewed by several "users". (n to m mapping) Which would be most efficient practice (regarding speed)? We want to figure the most efficient way to get the images that a user see? We want to handle 10 000 users and 100 000 images. *1* to create 3 tables:* user - info about a user images - info about an image user_image_mapping -> one row per association: user 1 -> image 22 user 1 -> image 8888 user 2 -> image 567 user 3 -> image 888 user 3 -> image 44453 *2* to create 2 tables* user - info about a user -> a field would contain a list which represents the ids of the images the user can look at? images - info about an image Any suggestion would be greatly appreciated, Best, Nicolas
