Splitting query results among machines?

[Brian Bray]

I am working on upgrading a program for a website I operate
(www.BookmarkTracker.com) which goes through a table of URL's and checks
each site for updates.  My program is currently multi-threaded so it can
check many websites simultaniously however I'm fast outgrowing even the
multi-threaded model and I need to start using multiple machines to do the
work.

My question is how do I run a query and then reliably split the results of
the query among multiple machines.  Say for example I do a SELECT * FROM
Bookmarks.  I want machine 1 to handle the first 1/3 of the
resulting rows, machine 2 the 2nd 1/3 and so on.

Any good Idea's?

Thanks in advance,

__Brian Bray______________________________________
  - Webmaster : http://www.BookmarkTracker.com -
  - Email     : webmaster@stripped   -