This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Performance in drop vs truncate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Performance in drop vs truncate" Watch "Performance in drop vs truncate" New topic
Author

Performance in drop vs truncate

Brusk Baran
Ranch Hand

Joined: Nov 15, 2001
Posts: 132
i create some temp tables....then:
if I try truncate first and then drop, it seems I have performance gain.
Do you experts advice this?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Performance in drop vs truncate
 
jQuery in Action, 3rd edition