[PERFORM] Sending a select to multiple servers.

2005-08-26 Thread Ligesh
I would like to know if the following kind of database client exists: I need a 'select' query to be sent to say 10 db servers simultaneously in parallel (using threading), the results should be re-sorted and returned. For example I have a query: 'select * from table where parent_clname =

Re: [PERFORM] Sending a select to multiple servers.

2005-08-26 Thread Frank Wiles
On Fri, 26 Aug 2005 20:54:09 +0530 Ligesh [EMAIL PROTECTED] wrote: I would like to know if the following kind of database client exists: I need a 'select' query to be sent to say 10 db servers simultaneously in parallel (using threading), the results should be re-sorted and returned.

Re: [PERFORM] Sending a select to multiple servers.

2005-08-26 Thread Merlin Moncure
Does such a solution exist now. To me this appears to be in entirety of what should constitute a database cluster. Only the search needs to be done on all the servers simultaneously at the low level. Once you get the results, the writing can be determined by the upper level logic (which can

Re: [PERFORM] Sending a select to multiple servers.

2005-08-26 Thread Ligesh
On Fri, Aug 26, 2005 at 11:04:59AM -0500, Frank Wiles wrote: On Fri, 26 Aug 2005 20:54:09 +0530 This is typically handled by the application layer, not a standard client. Mostly because every situation is different, you may have 10 servers and need 10 rows of results, others may need

Re: [PERFORM] Sending a select to multiple servers.

2005-08-26 Thread Ligesh
On Fri, Aug 26, 2005 at 11:04:59AM -0500, Frank Wiles wrote: On Fri, 26 Aug 2005 20:54:09 +0530 Ligesh [EMAIL PROTECTED] wrote: Mostly because every situation is different, you may have 10 servers and need 10 rows of results, others may need something entirely different. No. I