test100_innodb_50 ('yes'): 0.00021076202392578
test100_innodb_50 ('no'): 0.00019079446792603
test100_innodb_20 ('yes'): 0.00033247470855713
test100_innodb_20 ('no'): 0.00021946430206299
test100_innodb_5 ('yes'): 0.0001717209815979
test100_innodb_5 ('no'): 0.00030994415283203
test100_myisam_50 ('yes'): 0.00089478492736816
test100_myisam_50 ('no'): 0.00089174509048462
test100_myisam_20 ('yes'): 0.0011588931083679
test100_myisam_20 ('no'): 0.0014247894287109
test100_myisam_5 ('yes'): 0.0011542439460754
test100_myisam_5 ('no'): 0.0014210343360901
test1k_innodb_50 ('yes'): 0.0025214552879333
test1k_innodb_50 ('no'): 0.0026734471321106
test1k_innodb_20 ('yes'): 0.0015687346458435
test1k_innodb_20 ('no'): 0.0037298202514648
test1k_innodb_5 ('yes'): 0.0015367269515991
test1k_innodb_5 ('no'): 0.0044017434120178
test1k_myisam_50 ('yes'): 0.009192943572998
test1k_myisam_50 ('no'): 0.010978221893311
test1k_myisam_20 ('yes'): 0.010998487472534
test1k_myisam_20 ('no'): 0.011413931846619
test1k_myisam_5 ('yes'): 0.0093217492103577
test1k_myisam_5 ('no'): 0.011909544467926
test10k_innodb_50 ('yes'): 0.024333953857422
test10k_innodb_50 ('no'): 0.022818744182587
test10k_innodb_20 ('yes'): 0.014668464660645
test10k_innodb_20 ('no'): 0.030297219753265
test10k_innodb_5 ('yes'): 0.0099030137062073
test10k_innodb_5 ('no'): 0.038343966007233
test10k_myisam_50 ('yes'): 0.10269170999527
test10k_myisam_50 ('no'): 0.11138170957565
test10k_myisam_20 ('yes'): 0.11230754852295
test10k_myisam_20 ('no'): 0.17878025770187
test10k_myisam_5 ('yes'): 0.094968020915985
test10k_myisam_5 ('no'): 0.13118749856949
test100k_innodb_50 ('yes'): 0.28973346948624
test100k_innodb_50 ('no'): 0.44763833284378
test100k_innodb_20 ('yes'): 0.1353434920311
test100k_innodb_20 ('no'): 0.4273002743721
test100k_innodb_5 ('yes'): 0.17049676179886
test100k_innodb_5 ('no'): 0.6006401181221
test100k_myisam_50 ('yes'): 1.5740330219269
test100k_myisam_50 ('no'): 1.4418892860413
test100k_myisam_20 ('yes'): 1.3282124996185
test100k_myisam_20 ('no'): 1.3040364980698
test100k_myisam_5 ('yes'): 1.1947504281998
test100k_myisam_5 ('no'): 1.4856672883034
test1m_innodb_50 ('yes'): 2.5168477892876
test1m_innodb_50 ('no'): 2.3954140543938
test1m_innodb_20 ('yes'): 2.1470520496368
test1m_innodb_20 ('no'): 4.0717401504517
test1m_innodb_5 ('yes'): 4.3632462620735
test1m_innodb_5 ('no'): 5.5073730349541
test1m_myisam_50 ('yes'): 13.315396249294
test1m_myisam_50 ('no'): 13.351670503616
test1m_myisam_20 ('yes'): 10.34901201725
test1m_myisam_20 ('no'): 11.993644952774
test1m_myisam_5 ('yes'): 9.9596874713898
test1m_myisam_5 ('no'): 12.356516540051
test100_innodb_50 indexed ('yes'): 0.018645763397217 (slower)
test100_innodb_50 indexed ('no'): 0.014208495616913 (slower)
test100_innodb_20 indexed ('yes'): 0.00032150745391846 (faster)
test100_innodb_20 indexed ('no'): 0.010639011859894 (slower)
test100_innodb_5 indexed ('yes'): 0.00056374073028564 (slower)
test100_innodb_5 indexed ('no'): 0.0086361169815063 (slower)
test100_myisam_50 indexed ('yes'): 0.013743996620178 (slower)
test100_myisam_50 indexed ('no'): 0.011117815971375 (slower)
test100_myisam_20 indexed ('yes'): 0.004475474357605 (slower)
test100_myisam_20 indexed ('no'): 0.017294466495514 (slower)
test100_myisam_5 indexed ('yes'): 0.0015774965286255 (slower)
test100_myisam_5 indexed ('no'): 0.023766815662384 (slower)
test1k_innodb_50 indexed ('yes'): 0.0022639036178589 (faster)
test1k_innodb_50 indexed ('no'): 0.0022403597831726 (faster)
test1k_innodb_20 indexed ('yes'): 0.0019850134849548 (slower)
test1k_innodb_20 indexed ('no'): 0.0059282779693604 (slower)
test1k_innodb_5 indexed ('yes'): 0.00099468231201172 (faster)
test1k_innodb_5 indexed ('no'): 0.0054327845573425 (slower)
test1k_myisam_50 indexed ('yes'): 0.11488646268845 (slower)
test1k_myisam_50 indexed ('no'): 0.11610072851181 (slower)
test1k_myisam_20 indexed ('yes'): 0.049911558628082 (slower)
test1k_myisam_20 indexed ('no'): 0.19458723068237 (slower)
test1k_myisam_5 indexed ('yes'): 0.013106942176819 (slower)
test1k_myisam_5 indexed ('no'): 0.22532427310944 (slower)
test10k_innodb_50 indexed ('yes'): 0.0263432264328 (slower)
test10k_innodb_50 indexed ('no'): 0.026023089885712 (slower)
test10k_innodb_20 indexed ('yes'): 0.009400486946106 (faster)
test10k_innodb_20 indexed ('no'): 0.039997279644012 (slower)
test10k_innodb_5 indexed ('yes'): 0.0029674768447876 (faster)
test10k_innodb_5 indexed ('no'): 0.033475339412689 (faster)
test10k_myisam_50 indexed ('yes'): 1.1080477237701 (slower)
test10k_myisam_50 indexed ('no'): 1.1320183873177 (slower)
test10k_myisam_20 indexed ('yes'): 0.481485247612 (slower)
test10k_myisam_20 indexed ('no'): 1.9064459204674 (slower)
test10k_myisam_5 indexed ('yes'): 0.14789348840714 (slower)
test10k_myisam_5 indexed ('no'): 2.6357039809227 (slower)
test100k_innodb_50 indexed ('yes'): 0.27656102180481 (faster)
test100k_innodb_50 indexed ('no'): 0.2764505147934 (faster)
test100k_innodb_20 indexed ('yes'): 0.12268972396851 (faster)
test100k_innodb_20 indexed ('no'): 0.44757533073425 (slower)
test100k_innodb_5 indexed ('yes'): 0.025624811649323 (faster)
test100k_innodb_5 indexed ('no'): 0.48919320106506 (faster)
test100k_myisam_50 indexed ('yes'): 14.680316030979 (slower)
test100k_myisam_50 indexed ('no'): 14.244145214558 (slower)
test100k_myisam_20 indexed ('yes'): 6.7701337337494 (slower)
test100k_myisam_20 indexed ('no'): 24.188385546207 (slower)
test100k_myisam_5 indexed ('yes'): 1.6353840827942 (slower)
test100k_myisam_5 indexed ('no'): 27.757070481777 (slower)
test1m_innodb_50 indexed ('yes'): 3.0926967859268 (slower)
test1m_innodb_50 indexed ('no'): 3.1089668273926 (slower)
test1m_innodb_20 indexed ('yes'): 2.1711887717247 (slower)
test1m_innodb_20 indexed ('no'): 4.9384390711784 (slower)
test1m_innodb_5 indexed ('yes'): 1.2747210264206 (faster)
test1m_innodb_5 indexed ('no'): 6.5412267446518 (slower)