Mashiah Davidson skrev:
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.
Create the table without keys and add them later as needed when the table is populated. It is much faster insert when there is no keys to update for each inserted row.
Bst regards Byrial