Hello, All!

Can anyone suggest how to improve the performance of a query like this:

CREATE TABLE u_mashiah.pagelinks (
`pl_from` int(8) unsigned NOT NULL default '0',
`pl_namespace` int(11) NOT NULL default '0',
`pl_title` varchar(255) binary NOT NULL default '',
KEY `pl_from` (`pl_from`,`pl_namespace`)
) TYPE=MyISAM AS /* SLOW_OK */
SELECT pl_from,
       pl_namespace,
       pl_title
       FROM ruwiki_p.pagelinks;

This is the complete copying of a table from readonly database to personal one with some altering on keys, not sufficient I suppose. It looks like if copying like this is much slower than access to the same amount of data in one database.

Please, advise.

Mashiah