On Mon, Aug 22, 2005 at 01:46:23PM +0530, George Cherian wrote: > > > I need to run a particular 'select' on multiple machines, and then reorder > them. The query is: 'select * from table where parent_name = 'parent' order > by name limit 10. This query has to be sent to 10 servers - in series, > synchronously - the result (total of 100), should be resorted (each of the > ten rows from the server will be sorted, but the total would not be in > order), and then discard the 90, and return only the first 10 rows. >
Now that I thought it over, running the queries serially in a synchronous fashion is pure insanity. Actually it should create 10 threads, execute the 10 selects simultaneously, collate the results, order them, dump the 90 and return the 10. Thus this would be trivially able to scale to at least 700 servers simultaneously on a 256MB ram machine. Does such a solution exist now? Thanks a lot. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
