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