somewon Posted October 20, 2008 Share Posted October 20, 2008 I'm making a gallery site where all of the images are stored on another server. What I was originally doing is keeping the image links (in html) in a text file and reading them from there, but I figured it would be more efficient to use a mysql database instead. There are about 200 galleries with 50-100 links each, and constantly growing. Each link is about 20 characters long. What is the best way to handle this? Would it make sense to have a separate table for each gallery (I doubt it) or a single table with about 20,000 rows? Or maybe there's a better way to do this that I'm not thinking of, and that's probably the case. =b Link to comment https://forums.phpfreaks.com/topic/129159-need-to-store-thousands-of-html-links-in-mysql-database/ Share on other sites More sharing options...
AndyB Posted October 20, 2008 Share Posted October 20, 2008 one table with image link (and other image-relevant info maybe) plus the gallery number is what I'd use. Then you can retrieve all data for any specific gallery. Link to comment https://forums.phpfreaks.com/topic/129159-need-to-store-thousands-of-html-links-in-mysql-database/#findComment-669629 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.