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