This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "amount of text  - performance" Watch "amount of text  - performance" New topic

amount of text - performance

Mike Yu
Ranch Hand

Joined: Nov 17, 2001
Posts: 175
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...
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: amount of text - performance
Similar Threads
how to read binary data from socket
Limiting text in a JTextField
Performance of XML?
Birt vs Pentao vs Jasper reports
tips to improve the performance of my application