This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JDBC and the fly likes amount of text  - performance Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "amount of text  - performance" Watch "amount of text  - performance" New topic
Author

amount of text - performance

Mike Yu
Ranch Hand

Joined: Nov 17, 2001
Posts: 175
Hi,
If I insert a large amount of text into a column of varchar data type in a table, will this affect the performance of the database (DB2 UDB)?


Thanks,<br />Mike
Graham Thorpe
Ranch Hand

Joined: Mar 25, 2002
Posts: 265
at insert time there is not problem for performance .While retreiving time only it may affect performance affect .but not sure its depends upon the memory leaks may be server or databse etc...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: amount of text - performance