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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.