title: 40000 records in sdf - Performance
body: <p>I'm using sqlce 3.5 in Datalogic memor. </p>
  
  <ol>
  <li><strong>Importing 40,000 records</strong> to a table from other sdf inside this
  scanner, it takes for <strong>3 minutes</strong>.</li>
  <li><strong>Searching a field</strong> in this table, it takes <strong>4 seconds</strong>.</li>
  </ol>
  
  <p>Is it a normal time? Could we speed up?</p>
  
  <p>In this table, there are 6 fields below</p>
  
  <ol>
  <li>nvarchar 30</li>
  <li>nvarchar 26</li>
  <li>nvarchar 40</li>
  <li>nvarchar 13</li>
  <li>datetime</li>
  <li>nvarchar 20</li>
  </ol>
  
  <p>System searchs field 2 and then load field 2, 3 and 4.</p>
  
  <p>Thank you.</p>