Jump to content

Need to store (thousands) of html links in mysql database


somewon

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.