Greetings,
Buy 'Building Scalable Web Sites'
[http://www.oreillynet.com/pub/pr/1582], authored by the chief
architect of Flickr. Among other interesting topics, he describes the
system they use for full-text search. Its pretty simple, though this
is just one of the ways you can solve this problem
Ysgrifennodd Scott Haneda:
I have been looking at stock photo sites lately, started wondering how they
are doing their keyword searched. Given a potential for millions of images,
each with x keywords, I have come up with two approaches...
Is this the sort of thing you're looking for:
htt
I have been looking at stock photo sites lately, started wondering how they
are doing their keyword searched. Given a potential for millions of images,
each with x keywords, I have come up with two approaches...
Approach one
Images table, with a parent id
Keywords table, each keyword would be its