who can help me? ----- Original Message ----- From: "wangxu" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Wednesday, August 02, 2006 5:29 PM Subject: question about the query against to the federated engine tables
> I have a question about the query against to the federated engine tables. > As the following example: > > "select Id,name from e01_system.category" > Note: the "e01_system.category" is a federated table. > > I select only tow fields from the federated table "category" with the > above sql statement. But it seemed as if gets all the fields of the table > (the table has more then ten fields actually), so the performance of the sql > stetement is very slow when the table's size is very big.I conclude this > through monitoring the throughput of the network with a network tool named > "sniffer". I think the federated table works not as what i expected.
