Federated Tables versus Views

Federated Tables versus Views

am 08.10.2010 18:51:33 von Wellington Fan

--90e6ba1819c8edc23c04921dd373
Content-Type: text/plain; charset=ISO-8859-1

Hello All,

What should I consider when trying to choose between a Federated table and a
View when I have one table's data that I'd like to be available in other
databases on the same host.

My view definition would be something like:

CREATE
[some options]
VIEW
[this_db].[this_view] AS

SELECT
[some_db].[some_table].*
FROM
[some_db].[some_table].*


Are there performance gains to be had, one against the other? Security
concerns? Replication gotchas?

Thanks!

--90e6ba1819c8edc23c04921dd373--

RE: Federated Tables versus Views

am 08.10.2010 21:33:56 von Gavin Towey

Neither, really. You can qualify a table with the database name to operate=
on tables in multiple databases on the same host.

Federated is a way of accessing a table's data from a remote instance of my=
sql.


-----Original Message-----
From: winterbeef@gmail.com [mailto:winterbeef@gmail.com] On Behalf Of Welli=
ngton Fan
Sent: Friday, October 08, 2010 9:52 AM
To: mysql@lists.mysql.com
Subject: Federated Tables versus Views

Hello All,

What should I consider when trying to choose between a Federated table and =
a
View when I have one table's data that I'd like to be available in other
databases on the same host.

My view definition would be something like:

CREATE
[some options]
VIEW
[this_db].[this_view] AS

SELECT
[some_db].[some_table].*
FROM
[some_db].[some_table].*


Are there performance gains to be had, one against the other? Security
concerns? Replication gotchas?

Thanks!

This message contains confidential information and is intended only for the=
individual named. If you are not the named addressee, you are notified th=
at reviewing, disseminating, disclosing, copying or distributing this e-mai=
l is strictly prohibited. Please notify the sender immediately by e-mail i=
f you have received this e-mail by mistake and delete this e-mail from your=
system. E-mail transmission cannot be guaranteed to be secure or error-fre=
e as information could be intercepted, corrupted, lost, destroyed, arrive l=
ate or incomplete, or contain viruses. The sender therefore does not accept=
liability for any loss or damage caused by viruses or errors or omissions =
in the contents of this message, which arise as a result of e-mail transmis=
sion. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089,=
USA, FriendFinder.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg