aspose file tools*
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
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