Should formatting take place in QVD files?

[cmccafferty]

I am wondering if the process in which my daily load is taking soooooo long is because within the QVD files it is doing a lot of number formatting...

EG:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<QvdTableHeader>

   <QvBuildNo>7469</QvBuildNo>

   <CreatorDoc></CreatorDoc>

   <CreateUtcTime>2012-01-27 03:50:58</CreateUtcTime>

   <SourceCreateUtcTime></SourceCreateUtcTime>

   <SourceFileUtcTime></SourceFileUtcTime>

   <SourceFileSize>-1</SourceFileSize>

   <StaleUtcTime></StaleUtcTime>

   <TableName>Suppliers</TableName>

   <Fields>

     <QvdFieldHeader>

       <FieldName>SUP SupplierID</FieldName>

       <BitOffset>0</BitOffset>

       <BitWidth>13</BitWidth>

       <Bias>0</Bias>

       <NumberFormat>

         <Type>10</Type>

         <nDec>0</nDec>

         <UseThou>1</UseThou>

         <Fmt>###0</Fmt>

         <Dec>.</Dec>

         <Thou></Thou>

       </NumberFormat>

       <NoOfSymbols>4514</NoOfSymbols>

       <Offset>0</Offset>

       <Length>22570</Length>

     </QvdFieldHeader>

...... there is a lot more lines like this too.

Does this need to be done at the QVD stage as I could easily change the formatting at the QVW stage.

Please to advise.

Chris

[gandalfgray]

I do not think so.

Anyway I do not know of any way to tell QV not to store that info in the qvd file.

If you do not have logging on in your loading qvw:s, turn that on, and look in the logs what statements are taking a long time to execute.

br

/GandalfGray