---- How do large websites design their database structure
Imaster - 4:23 am on Mar 23, 2007 (gmt 0)
Well, they might not even store their photos in the database. They could have records pointing to the location of the photos on the file server.
Yes, I am aware of that. They maintain the photos on the filesystem and there are simply records in the mysql tables to reference them. I am however talking about the MySql Table structure. For eg: if there are millions of photos, the records for these millions are held in one single table or they are partitioned [dev.mysql.com]?