I love writing code and I am passionate about it...
My "favorite/most-used programming language" changed from age 10 until now: QuickBasic->TurboPascal->C->C#->Python
|
Apr
10 |
|
awarded | Notable Question |
|
Mar
22 |
|
awarded | Popular Question |
|
Jan
28 |
|
awarded | Popular Question |
|
Jan
25 |
|
awarded | Good Question |
|
Jan
11 |
|
awarded | Notable Question |
|
Dec
30 |
|
awarded | Good Question |
|
Dec
17 |
|
awarded | Famous Question |
|
Nov
26 |
|
awarded | Notable Question |
|
Nov
21 |
|
awarded | Famous Question |
|
Nov
7 |
|
awarded | Yearling |
|
Sep
17 |
|
awarded | Nice Question |
|
Sep
6 |
|
awarded | Great Question |
|
Aug
1 |
|
awarded | Famous Question |
|
Jul
17 |
|
awarded | Supporter |
|
Jul
17 |
|
comment |
Simple MySQL INSERT query on simple InnoDB table takes 40+ms I've just tested with SSD and confirmed that bigger factor in query time is disk. With modest SSD, but still with much lower access latency, INSERT query time is significantly lower (~10ms). |
|
Jul
17 |
|
comment |
Simple MySQL INSERT query on simple InnoDB table takes 40+ms Makes sense. I'll try today later same thing on SSD (this was on rather slow 5k4 hdd). |
|
Jul
16 |
|
comment |
Simple MySQL INSERT query on simple InnoDB table takes 40+ms Tables are empty prior to test. Freshly created tables and given insert queries gives these timings... |
|
Jul
16 |
|
comment |
Simple MySQL INSERT query on simple InnoDB table takes 40+ms Update query (for example) "update test_table_innodb set int_column = 5 where id = 3" takes even more time (50+ms). |
|
Jul
16 |
|
comment |
Simple MySQL INSERT query on simple InnoDB table takes 40+ms I saw the edit, thanks for useful info. But, I'm still under impression that maximum rate of 25 of these inserts per sec even for out-of-the-box MySQL server is ridiculously low. Even if by optimal configuration I get 50% better performance, it's still seeming low... |
|
Jul
16 |
|
comment |
Simple MySQL INSERT query on simple InnoDB table takes 40+ms it's fully out-of-the-box :) |
