https://bugzilla.wikimedia.org/show_bug.cgi?id=37455
--- Comment #3 from Maarten Dammers <maar...@mdammers.nl> 2012-12-01 21:42:58 UTC --- Did a first implementation. CREATE TABLE `image` ( `country` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `id` varchar(25) NOT NULL DEFAULT '0', `img_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`country`,`id`,`img_name`), KEY `country_id` (`country`,`id`), KEY `img_name` (`img_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 mysql> SELECT COUNT(*) FROM image; +----------+ | COUNT(*) | +----------+ | 878926 | +----------+ 1 row in set (0.00 sec) Playing around with api at http://toolserver.org/~multichill/monapi/api.php?action=images&country=pl&id=MA/A-1028&format=json&width=2000&limit=999999 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
