Who will use more memory Dataset or Seq. file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 16
- Joined: Fri Oct 27, 2006 6:27 am
Who will use more memory Dataset or Seq. file
If the data inserted into sequential file and same data stored in dataset, which will require more memory? Dataset Or Sequentail file.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Are you using unbounded VarChar data types (where no maximum length is specified)? Are you using bounded VarChar data types (where a maximum length is specified)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 16
- Joined: Fri Oct 27, 2006 6:27 am
Ray - thanks for catching that; I had forgotten that DataSets will pad out VarChar strings and thus can use significantly more disk storage. We had a case here recently where a VarChar(800) column was used to store 15 characters of data - but for millions of rows. Just changing the data type significantly reduced the size and therefore the speed of the DataSet.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 23
- Joined: Fri Mar 28, 2003 5:41 pm
- Location: USA
Further...
So, do I have this correct? Unbounded VarChar strings are greatly discouraged by the manufacturer. Bounded VarChars too have their pitfalls. A dataset will allocate the maximum declared length for a VarChar. If you specify a max length that is too big, then you waste lots of space and slow things down. Right?ArndW wrote:Ray - thanks for catching that; I had forgotten that DataSets will pad out VarChar strings and thus can use significantly more disk storage. We had a case here recently where a VarChar(800) column was used to store 15 characters of data - but for millions of rows. Just changing the data type significantly reduced the size and therefore the speed of the DataSet.
EPCCTX