Re: 1000$ if implemented
I have tested the solution using a view. The first problem is that I don't need a union of the results I need a "merge" of the results. This means that if I run the following query on the view:
select username, sum(`money spent`)
This returns the following two results on the FEDERATED tables referenced by the view:
|-------------------------
|Username| `money spent` |
|--------|---------------|
|user1 | 1000 |
|user2 | 100 |
--------------------------
|-------------------------
|Username| `money spent` |
|--------|---------------|
|user1 | 1000 |
|user2 | 100 |
--------------------------
Then the view should not return the union like the following:
|-------------------------
|Username| `money spent` |
|--------|---------------|
|user1 | 1000 |
|user2 | 100 |
|user1 | 1000 |
|user2 | 100 |
--------------------------
But rather a "merged" result like the following:
|-------------------------
|Username| `money spent` |
|--------|---------------|
|user1 | 2000 |
|user2 | 200 |
--------------------------
The second problem with using a view is that it seems to pass the queries onto the underlying tables in sequence, meaning that it waits for the first federated table to return its results before it sends the query to the second federated table.
The third problem is that no processing seems to get done on the remote server referenced by the FEDERATED table, meaning that it simply sends a select * from XXX to the remote server, as I have large amounts of data this means that it takes too long to transfer the data over the network, and the distribution of the workload onto different computers, which is my intention, is not accomplished.
Subject
Views
Written By
Posted
9044
June 18, 2007 02:56AM
5209
June 18, 2007 05:13AM
4622
June 18, 2007 06:43PM
5965
June 19, 2007 12:00AM
4506
June 19, 2007 10:03AM
5501
June 27, 2007 05:59PM
4793
June 27, 2007 06:51PM
4432
June 28, 2007 02:47AM
Re: 1000$ if implemented
4515
June 28, 2007 03:24AM
4347
June 28, 2007 06:15AM
4864
July 06, 2007 08:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.