I'd like to design a rather simple image organizer, similar to iPhoto, Aperture, Lightroom, etc. (without the image adjustment features--I just want to organize them)
Reason being, (as a photographer) I'd like to be able to access my files from anywhere and this seems to be the best (if not easiest) way to do it.
That said, I need something that will first:
- track 5000-20000 image files (yeah, I know... I overshoot)
- add tags to each image (and sort by combos of those tags)
I'm sure I'll add more stuff as it develops, but that's where I want to start.
So. Obviously, if I were only doing this for a couple hundred files, I could be done in 30 minutes.
LAST time I tried this though, it gave out and stopped working very well around 3000 images.
Therefore, questions:
- Is there some different way I should store this data given how many entries I'll have?
- Is there anything special I should know about pagination other than "LIMIT 10,20" ?
Hopefully these aren't dumb questions. I just don't want to start on it and then have it freak out once I add so many images...
Thanks!!