Re: [Sqlrelay-discussion] send selects to multiple servers

[Firstworks/4access <dav...@fi...>]

Sorry, SQL Relay can't currently do anything like that, at least not
automatically.

There are only 2 way I know of to do that with any database.  The first
is for your program to connect to all 10 databases, run the queries and
collate the results itself.  The second is to go into one database and
create a dblink (ie. a link between separate databases, this is only
supported by commercial databases like oracle, sybase, etc.) to each of
the other 9 databases and then run a "select distinct" against all 10
tables.

I have a list of things like that that it would be nice for SQL Relay to
do called "database gymnastics" but I haven't gotten around to working
on them.  Maybe in the future it will support something like that, but
today it doesn't.

David Muse
dav...@fi...

On Mon, 2005-08-22 at 14:08 +0530, George Cherian wrote:
>  Hi,
> 
>   Sql relay looks cool. I would like to know if it fits the job I want to do... What I need is to run a 'select' on multiple machines in parallel - asynchronously -, resort the result and return the rows.  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 parallel - 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.
> 
> 
>  Can sql relay do this? I am really new to database, so please bear with me if it is a silly question.
> 
>  Thanks a lot in advance.
> 
>  George.
> 
> 
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>