MySQL Forums
Forum List  »  Performance

Re: Slow Query Urgent
Posted by: Peter Brawley
Date: July 23, 2015 10:19AM

Dropping & recreating the same table every few mins is inefficient. Why not just truncate it?

Of course if another processs is still using the table, Truncate will also have to wait. Probably you'll need to revisit the algorithm.

Options: ReplyQuote


Subject
Views
Written By
Posted
1600
a m
July 23, 2015 09:21AM
Re: Slow Query Urgent
710
July 23, 2015 10:19AM
696
July 24, 2015 04:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.