Help our (Drupal-based) project which tracks online censorship in China

Yes, there are external javascript but I'm not concerned with those right now. I'm measuring the time to download the html only using Apache Benchmark and that frequently takes 20s+.

Hi Dave,

Thanks a lot for lots of useful info! I've downloaded apc.php and placed it here: http://www.greatfirewall.biz/apc.php. Right now Cache full count is 364 (very bad?) and there seems to be a lot of fragmentation. I had already increased the memory size in php.ini to apc.shm_size 512M. However, in apc.php it says that shared memory is 1 Segment(s) with 30.0 MBytes (mmap memory, pthread mutex locking). Any idea why the two values are different?

The APC lines I've added to my settings.php are these:
$conf['cache_backends'] = array('sites/all/modules/apc/drupal_apc_cache.inc');
$conf['cache_class_cache'] = 'DrupalAPCCache';
$conf['cache_class_cache_bootstrap'] = 'DrupalAPCCache';

I ran a search on the website and this is the output from Devel: Executed 234 queries in 15557.12 ms. Queries exceeding 5 ms are highlighted. Page execution time was 18919.42 ms.

The slowest query by far was:
6402.771
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_entity_node.cid AS cid, cache_entity_node.data AS data, cache_entity_node.created AS created, cache_entity_node.expire AS expire, cache_entity_node.serialized AS serialized FROM cache_entity_node cache_entity_node WHERE (cache_entity_node.cid IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8, :db_condition_placeholder_9, :db_condition_placeholder_10, :db_condition_placeholder_11, :db_condition_placeholder_12, :db_condition_placeholder_13, :db_condition_placeholder_14, :db_condition_placeholder_15, :db_condition_placeholder_16, :db_condition_placeholder_17, :db_condition_placeholder_18, :db_condition_placeholder_19, :db_condition_placeholder_20, :db_condition_placeholder_21, :db_condition_placeholder_22, :db_condition_placeholder_23, :db_condition_placeholder_24, :db_condition_placeholder_25, :db_condition_placeholder_26, :db_condition_placeholder_27, :db_condition_placeholder_28, :db_condition_placeholder_29, :db_condition_placeholder_30, :db_condition_placeholder_31, :db_condition_placeholder_32, :db_condition_placeholder_33, :db_condition_placeholder_34, :db_condition_placeholder_35, :db_condition_placeholder_36, :db_condition_placeholder_37, :db_condition_placeholder_38, :db_condition_placeholder_39, :db_condition_placeholder_40, :db_condition_placeholder_41, :db_condition_placeholder_42, :db_condition_placeholder_43, :db_condition_placeholder_44, :db_condition_placeholder_45, :db_condition_placeholder_46, :db_condition_placeholder_47, :db_condition_placeholder_48, :db_condition_placeholder_49, :db_condition_placeholder_50, :db_condition_placeholder_51, :db_condition_placeholder_52, :db_condition_placeholder_53, :db_condition_placeholder_54, :db_condition_placeholder_55, :db_condition_placeholder_56, :db_condition_placeholder_57, :db_condition_placeholder_58, :db_condition_placeholder_59, :db_condition_placeholder_60, :db_condition_placeholder_61, :db_condition_placeholder_62, :db_condition_placeholder_63, :db_condition_placeholder_64, :db_condition_placeholder_65, :db_condition_placeholder_66, :db_condition_placeholder_67, :db_condition_placeholder_68, :db_condition_placeholder_69, :db_condition_placeholder_70, :db_condition_placeholder_71, :db_condition_placeholder_72, :db_condition_placeholder_73, :db_condition_placeholder_74, :db_condition_placeholder_75, :db_condition_placeholder_76, :db_condition_placeholder_77, :db_condition_placeholder_78, :db_condition_placeholder_79, :db_condition_placeholder_80, :db_condition_placeholder_81, :db_condition_placeholder_82, :db_condition_placeholder_83, :db_condition_placeholder_84, :db_condition_placeholder_85, :db_condition_placeholder_86, :db_condition_placeholder_87, :db_condition_placeholder_88, :db_condition_placeholder_89, :db_condition_placeholder_90, :db_condition_placeholder_91, :db_condition_placeholder_92, :db_condition_placeholder_93, :db_condition_placeholder_94, :db_condition_placeholder_95, :db_condition_placeholder_96, :db_condition_placeholder_97, :db_condition_placeholder_98, :db_condition_placeholder_99))

Thanks a lot for your help! If you want to get more involved with the project you're welcome to. There's a lot to work on.