<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Hi,</p>
    <p>Glad to hear that it helped to run the operations on a closed
      table. Nevertheless, as Luigi said, it would make sense to submit
      an issue report about this slowness.<br>
    </p>
    <p>The other thing one has to keep on mind:</p>
    <p>The SQLite API is kind of limited. Only until recently, if you
      wanted to rename a field, one had to copy the whole table with the
      renamed field changed in the new table - then the old table had to
      be removed (all in the background), because there was API to
      rename columns in SQLite. I think with the very recent version,
      which is not rolled out into most OS, this has changed. You'd also
      need a very recent GDAL/OGR.<br>
    </p>
    Greetings,<br>
    Andreas<br>
    <br>
    <div class="moz-cite-prefix">Am 03.10.2018 um 21:20 schrieb Kelley
      Jabr:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAMhACaEXpfg4sL2UAyurN6JBnks+nGbtvXODM5zr6RDZG_kDgA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=utf-8">
      <div dir="ltr">Luigi, I'm pretty sure you just solved my problem.
        I tried a few operations with the table closed and it was like
        night and day. That 400k field calculator finished in mere
        moments! Thank you!!</div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr">On Wed, Oct 3, 2018 at 1:42 PM Luigi Pirelli <<a
            href="mailto:luipir@gmail.com" moz-do-not-send="true">luipir@gmail.com</a>>
          wrote:<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0 0 0
          .8ex;border-left:1px #ccc solid;padding-left:1ex">
          <div dir="ltr">can you test doing operations with field
            calculator without having the attribute table opened? just a
            workaround could be to use a virtual layer then save the
            entire layer later.
            <div>
              <div><br clear="all">
                <div>
                  <div dir="ltr"
                    class="m_-237128707789312989gmail_signature"
                    data-smartmail="gmail_signature">Luigi Pirelli<br>
                    <br>
**************************************************************************************************<br>
                    * LinkedIn: <a
                      href="https://www.linkedin.com/in/luigipirelli"
                      target="_blank" moz-do-not-send="true">https://www.linkedin.com/in/luigipirelli</a><br>
                    * Stackexchange: <a
                      href="http://gis.stackexchange.com/users/19667/luigi-pirelli"
                      target="_blank" moz-do-not-send="true">http://gis.stackexchange.com/users/19667/luigi-pirelli</a><br>
                    * GitHub: <a href="https://github.com/luipir"
                      target="_blank" moz-do-not-send="true">https://github.com/luipir</a><br>
                    * Mastering QGIS 2nd Edition:<br>
                    * <a
href="https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition"
                      target="_blank" moz-do-not-send="true">https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition</a><br>
                    * Hire me: <a href="http://goo.gl/BYRQKg"
                      target="_blank" moz-do-not-send="true">http://goo.gl/BYRQKg</a><br>
**************************************************************************************************</div>
                </div>
                <br>
              </div>
            </div>
          </div>
          <br>
          <div class="gmail_quote">
            <div dir="ltr">On Wed, 3 Oct 2018 at 18:11, Kelley Jabr <<a
                href="mailto:kjabr@indeed.com" target="_blank"
                moz-do-not-send="true">kjabr@indeed.com</a>> wrote:<br>
            </div>
            <blockquote class="gmail_quote" style="margin:0 0 0
              .8ex;border-left:1px #ccc solid;padding-left:1ex">
              <div dir="ltr">Hello,
                <div><br>
                </div>
                <div>I'm working with a geopackage on ~530k features,
                  and just about everything I try to do in the table
                  takes way longer than expected. </div>
                <div>
                  <ul>
                    <li>Adding a field took 5 minutes (table now has 22
                      total fields, so not massive)<br>
                    </li>
                    <li>Field Calculator on ~32k selected records took 8
                      minutes (literally all I was putting in the cells
                      was: N)</li>
                    <li>Field calculator on ~480k records took so many
                      hours that I had to leave it running over the
                      weekend and when I came back, the Field Calculator
                      had "closed unexpectedly"</li>
                  </ul>
                  <div>(I'm running on a linux machine with an Intel
                    Core i7 and 32GB of memory.)</div>
                  <div><br>
                  </div>
                  <div>Has anyone else experience similar issues? Any
                    advice or recommendations for how to improve
                    performance here? </div>
                  <div><br>
                  </div>
                  <div>Thank you,</div>
                  <div><br>
                  </div>
                  -- <br>
                  <div dir="ltr"
                    class="m_-237128707789312989m_7860919606024074194gmail_signature"
                    data-smartmail="gmail_signature">
                    <div dir="ltr">
                      <div dir="ltr"><span>
                          <p dir="ltr"
                            style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:"Helvetica Neue";color:rgb(0,0,0);background-color:transparent;font-weight:700;vertical-align:baseline;white-space:pre-wrap">Kelley Jabr</span></p>
                          <p
                            style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><font
                              color="#000000" face="Helvetica Neue"><span style="font-size:13.3333px;white-space:pre-wrap">Analyst, Geographic Data Operations</span></font></p>
                          <p dir="ltr"
                            style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:"Helvetica Neue";color:rgb(0,0,255);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><a href="mailto:kjabr@indeed.com" target="_blank" moz-do-not-send="true">kjabr@indeed.com</a></span></p>
                          <div><br>
                          </div>
                        </span></div>
                    </div>
                  </div>
                </div>
              </div>
              _______________________________________________<br>
              Qgis-user mailing list<br>
              <a href="mailto:Qgis-user@lists.osgeo.org" target="_blank"
                moz-do-not-send="true">Qgis-user@lists.osgeo.org</a><br>
              List info: <a
                href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
                rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
              Unsubscribe: <a
                href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
                rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote>
          </div>
        </blockquote>
      </div>
      <br clear="all">
      <div><br>
      </div>
      -- <br>
      <div dir="ltr" class="gmail_signature"
        data-smartmail="gmail_signature">
        <div dir="ltr">
          <div>
            <div dir="ltr"><span>
                <p dir="ltr"
                  style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:"Helvetica Neue";color:rgb(0,0,0);background-color:transparent;font-weight:700;vertical-align:baseline;white-space:pre-wrap">Kelley Jabr</span></p>
                <p
                  style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><font
                    color="#000000" face="Helvetica Neue"><span style="font-size:13.3333px;white-space:pre-wrap">Analyst, Geographic Data Operations</span></font></p>
                <p dir="ltr"
                  style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:"Helvetica Neue";color:rgb(0,0,255);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><a href="mailto:kjabr@indeed.com" target="_blank" moz-do-not-send="true">kjabr@indeed.com</a></span></p>
                <br>
                <p dir="ltr"
                  style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:"Helvetica Neue";color:rgb(0,0,255);background-color:transparent;vertical-align:baseline;white-space:pre-wrap">Indeed</span><span style="font-size:10pt;font-family:"Helvetica Neue";color:rgb(255,153,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"> - We help people get jobs.</span></p>
                <p dir="ltr"
                  style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:"Helvetica Neue";color:rgb(0,0,255);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><a href="http://www.indeed.com" target="_blank" moz-do-not-send="true">Indeed.com</a></span></p>
                <div><br>
                </div>
              </span></div>
          </div>
        </div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
    </blockquote>
    <br>
  </body>
</html>