<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Thanks that “</span>Export->Save Features, ticking Save Only Selected Features” worked fine, took just a few seconds.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Have not tried the other suggestion from someone else about the spatial index but the file I was pasting into was empty so I am not sure it had a spatial index to start with.<span style="mso-fareast-language:EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> David Strip <qgis-user@stripfamily.net>
<br>
<b>Sent:</b> Monday, July 4, 2022 5:15 PM<br>
<b>To:</b> Michael.Dodd <michael.dodd@open.ac.uk>; 'qgis-user@lists.osgeo.org' <qgis-user@lists.osgeo.org><br>
<b>Subject:</b> Re: [Qgis-user] copy and paste very slow in qgis<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-element:para-border-div;border:solid black 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt;background:#FFFFCC">
<p style="background:#FFFFCC;border:none;padding:0cm"><span style="font-family:"Arial",sans-serif;color:black">CAUTION: This mail comes from outside the University. Please consider this before opening attachments, clicking links, or acting on the content.
</span><span style="font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal">On 7/4/2022 9:03 AM, Michael.Dodd via Qgis-user wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I am trying to copy points with their attributes from one layer to another (actually one geopackage file to another), the select is quick, couple of mins, bearing in mind there
are 800,000 points but when pasting into the new empty geopackage file it is extremely slow. Less than 10% of the points need to be pasted but it was taking 40mins before I stopped it and I had no idea how much longer it would take. There was a hint that it
may have done about 30,000 in 40mins.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Is there another way to do this, I have also tried switching the selection and deleting the other 90% but this too is very slow and don’t see the end.<o:p></o:p></p>
</blockquote>
<p class="MsoNormal">Have you tried selecting the features, then Export->Save Features, ticking Save Only Selected Features?<o:p></o:p></p>
</div>
</div>
</body>
</html>