select SQL_CACHE * from meta_table where tablename like "users%" current_table: users_04 select SQL_CACHE * from users_00 where login = 'notsolonely21' count (myarray) : 0 select SQL_CACHE * from users_01 where login = 'notsolonely21' count (myarray) : 0 select SQL_CACHE * from users_02 where login = 'notsolonely21' count (myarray) : 0 select SQL_CACHE * from users_03 where login = 'notsolonely21' count (myarray) : 0 select SQL_CACHE * from users_04 where login = 'notsolonely21' count (myarray) : 1 count > 1 4 <= 4 Array ( [0] => Array ( [id] => 9333 [login] => notsolonely21 [email] => [im] => [twitter] => [pass] => *998DF573F2C0CF4D0331753EE983DAC15963DDD9 [datejoined] => ) ) Elapsed time between Start and Test_Code_Partition: 0.059307 partition sql: select SQL_CACHE * from users where login = 'notsolonely21' Elapsed time between Test_Code_Partition and DB_Partition: 0.005882 Elapsed time between DB_Partition and No_Partition: 0.003694 ------------------------------------------------------------------ marker time index ex time perct ------------------------------------------------------------------ Start 1176964205.32067900 - 0.00% ------------------------------------------------------------------ Test_Code_Partition 1176964205.37998600 0.059307 85.83% ------------------------------------------------------------------ DB_Partition 1176964205.38586800 0.005882 8.51% ------------------------------------------------------------------ No_Partition 1176964205.38956200 0.003694 5.35% ------------------------------------------------------------------ Stop 1176964205.38978100 0.000219 0.32% ------------------------------------------------------------------ total - 0.069102 100.00% ------------------------------------------------------------------