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.
Good luck, Mark On 7/19/07, Peter Bradley <[EMAIL PROTECTED]> wrote:
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... > > <snip /> Is this the sort of thing you're looking for: http://en.wikipedia.org/wiki/Inverted_index It's the sort of structure used in library software. Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Mark Papadakis http://www.markpapadakis.com/ [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]