FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » SQL Optimization (or maybe the ISP doesn't know what they are talking about)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Return to the default flat view Create a new topic Submit Reply
SQL Optimization [message #161212] Tue, 24 November 2009 22:47 Go to previous message
Tesla Rider is currently offline  Tesla Rider   
Messages: 20
Registered: June 2009
Karma:
Junior Member
add to buddy list
ignore all messages by this user
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?
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Index command denied
Next Topic: Looking for MySQL web hosting
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 23 15:11:11 EDT 2017

Total time taken to generate the page: 0.00744 seconds