| SQL Optimization [message #161212] |
Wed, 25 November 2009 03:47  |
art
Messages: 35
Registered: June 2009
Karma: 0
|
Member |
|
|
Recently, my ISP complained that my database usage was too high and shut me down. This is one of the reasons they gave:
Time: 29% (7230 sec) Amount: 25% (446 queries) Rows Examined/Sent: 0 / 0 Avg. Query Exec/Lock Time: 16 / 7 sec.
use my_forum; INSERT INTO fud28_ses (ses_id, time_sec, sys_id, user_id) VALUES ('5a4f44865d9ab78f5fe9db19d3bd943c', 1258704641, '7e891bc61071df49e48390596180088c', 2142232494);
Now when I look at that, I think to myself, how in the world can a simple insert like that take an average of over 16 seconds per statement. I think it was the server, not the statement. But maybe some of you will see something I don't.
What say you?
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]