Re: Huge AUP3 project issue

Steve Fiddle <[email protected]> Thu, 20 May 2021 10:40:34 +0100
Newsgroups gmane.comp.audio.audacity.devel
Message-ID <CABp83eBtt=a1LuvaD_-Fo7PuuZh+n==ut4LM9GaPMXs5dkPJfQ@mail.gmail.com>
--===============1870964508714869620==
Content-Type: multipart/alternative; boundary="0000000000004ea3b005c2bfbe7f"

--0000000000004ea3b005c2bfbe7f
Content-Type: text/plain; charset="UTF-8"

It looks like we may not be escaping single quotes somewhere.
Logged on bugzilla: https://bugzilla.audacityteam.org/show_bug.cgi?id=2793

Steve

On Tue, 18 May 2021 at 14:31, Steve Fiddle <[email protected]> wrote:

> He has sent me the huge file (445 MB as 7z) and I can make it
> available to any developer that wants to take a look, but he has asked
> me not to make the project public, so I'll send a link to the file on
> request.
>
> On my (Linux) computer with Audacity 3.0.2, I can open the file,
> reverse the first track, Undo, Save, Exit, and the file shrinks to 186
> MiB. So it seems that "something" is stopping compaction from working
> on his (Windows 10) machine.
>
> Conjecture: Perhaps this is also related to the extreme slowness that
> some  users are experiencing.
>
> Steve
>
> On Mon, 17 May 2021 at 16:27, Steve Fiddle <[email protected]>
> wrote:
> >
> > On Mon, 17 May 2021 at 04:59, Leland <[email protected]> wrote:
> > >
> > > Steve, have him open the project, duplicate a track, reverse the new
> track,
> > > save the project, delete the new track, save again.  Does the project
> reduce
> > > in size then?
> > > (Basically, trying to force compaction.)
> >
> > Weird. He tried that, and here's what happened:
> >
> > "The file size did not change.
> > Also, when I duplicated the tracks, reversed them, and saved them, the
> > file size also didn't change.
> > To check my sanity, I looked at the property and the modification time
> > is changing."
> >
> > I've asked him if he could make a ZIP archive of the AUP3 and see what
> > size that is. That may give an indication of whether the extra size is
> > due to data in the database, or empty space. It may also reduce the
> > project to a manageable size to send to us.
> >
> > Steve
> >
> >
> > >
> > > -----Original Message-----
> > > From: Steve Fiddle <[email protected]>
> > > Sent: Sunday, May 16, 2021 7:34 PM
> > > To: Audacity-Devel list <[email protected]>
> > > Subject: [Audacity-devel] Huge AUP3 project issue
> > >
> > > We have a report on the forum of a 200MB project (expected size)
> having a
> > > saved file size of 1350MB.
> > >
> > > On opening the 1.35GB project and saving a backup copy of the project,
> the
> > > backup project file is under 200 MB, which is about right for the
> amount of
> > > audio in the project.
> > >
> > > The forum thread is here:
> > > https://forum.audacityteam.org/viewtopic.php?f=46&t=118141
> > >
> > >
> > > Steve
> > >
> > >
> > > _______________________________________________
> > > audacity-devel mailing list
> > > [email protected]
> > > https://lists.sourceforge.net/lists/listinfo/audacity-devel
> > >
> > >
> > >
> > > _______________________________________________
> > > audacity-devel mailing list
> > > [email protected]
> > > https://lists.sourceforge.net/lists/listinfo/audacity-devel
>

--0000000000004ea3b005c2bfbe7f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>It looks like we may not be escaping single quotes so=
mewhere.</div><div>Logged on bugzilla: <a href=3D"https://bugzilla.audacity=
team.org/show_bug.cgi?id=3D2793">https://bugzilla.audacityteam.org/show_bug=
.cgi?id=3D2793</a></div><div><br></div><div>Steve<br></div></div><br><div c=
lass=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, 18 May 2=
021 at 14:31, Steve Fiddle &lt;<a href=3D"mailto:[email protected]">=
[email protected]</a>&gt; wrote:<br></div><blockquote class=3D"gmail=
_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204=
,204);padding-left:1ex">He has sent me the huge file (445 MB as 7z) and I c=
an make it<br>
available to any developer that wants to take a look, but he has asked<br>
me not to make the project public, so I&#39;ll send a link to the file on<b=
r>
request.<br>
<br>
On my (Linux) computer with Audacity 3.0.2, I can open the file,<br>
reverse the first track, Undo, Save, Exit, and the file shrinks to 186<br>
MiB. So it seems that &quot;something&quot; is stopping compaction from wor=
king<br>
on his (Windows 10) machine.<br>
<br>
Conjecture: Perhaps this is also related to the extreme slowness that<br>
some=C2=A0 users are experiencing.<br>
<br>
Steve<br>
<br>
On Mon, 17 May 2021 at 16:27, Steve Fiddle &lt;<a href=3D"mailto:stevethefi=
[email protected]" target=3D"_blank">[email protected]</a>&gt; wrote:<b=
r>
&gt;<br>
&gt; On Mon, 17 May 2021 at 04:59, Leland &lt;<a href=3D"mailto:llucius@hom=
erow.net" target=3D"_blank">[email protected]</a>&gt; wrote:<br>
&gt; &gt;<br>
&gt; &gt; Steve, have him open the project, duplicate a track, reverse the =
new track,<br>
&gt; &gt; save the project, delete the new track, save again.=C2=A0 Does th=
e project reduce<br>
&gt; &gt; in size then?<br>
&gt; &gt; (Basically, trying to force compaction.)<br>
&gt;<br>
&gt; Weird. He tried that, and here&#39;s what happened:<br>
&gt;<br>
&gt; &quot;The file size did not change.<br>
&gt; Also, when I duplicated the tracks, reversed them, and saved them, the=
<br>
&gt; file size also didn&#39;t change.<br>
&gt; To check my sanity, I looked at the property and the modification time=
<br>
&gt; is changing.&quot;<br>
&gt;<br>
&gt; I&#39;ve asked him if he could make a ZIP archive of the AUP3 and see =
what<br>
&gt; size that is. That may give an indication of whether the extra size is=
<br>
&gt; due to data in the database, or empty space. It may also reduce the<br=
>
&gt; project to a manageable size to send to us.<br>
&gt;<br>
&gt; Steve<br>
&gt;<br>
&gt;<br>
&gt; &gt;<br>
&gt; &gt; -----Original Message-----<br>
&gt; &gt; From: Steve Fiddle &lt;<a href=3D"mailto:[email protected]=
" target=3D"_blank">[email protected]</a>&gt;<br>
&gt; &gt; Sent: Sunday, May 16, 2021 7:34 PM<br>
&gt; &gt; To: Audacity-Devel list &lt;<a href=3D"mailto:audacity-devel@list=
s.sourceforge.net" target=3D"_blank">[email protected]</=
a>&gt;<br>
&gt; &gt; Subject: [Audacity-devel] Huge AUP3 project issue<br>
&gt; &gt;<br>
&gt; &gt; We have a report on the forum of a 200MB project (expected size) =
having a<br>
&gt; &gt; saved file size of 1350MB.<br>
&gt; &gt;<br>
&gt; &gt; On opening the 1.35GB project and saving a backup copy of the pro=
ject, the<br>
&gt; &gt; backup project file is under 200 MB, which is about right for the=
 amount of<br>
&gt; &gt; audio in the project.<br>
&gt; &gt;<br>
&gt; &gt; The forum thread is here:<br>
&gt; &gt; <a href=3D"https://forum.audacityteam.org/viewtopic.php?f=3D46&am=
p;t=3D118141" rel=3D"noreferrer" target=3D"_blank">https://forum.audacityte=
am.org/viewtopic.php?f=3D46&amp;t=3D118141</a><br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; Steve<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; _______________________________________________<br>
&gt; &gt; audacity-devel mailing list<br>
&gt; &gt; <a href=3D"mailto:[email protected]" target=3D=
"_blank">[email protected]</a><br>
&gt; &gt; <a href=3D"https://lists.sourceforge.net/lists/listinfo/audacity-=
devel" rel=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/l=
ists/listinfo/audacity-devel</a><br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; _______________________________________________<br>
&gt; &gt; audacity-devel mailing list<br>
&gt; &gt; <a href=3D"mailto:[email protected]" target=3D=
"_blank">[email protected]</a><br>
&gt; &gt; <a href=3D"https://lists.sourceforge.net/lists/listinfo/audacity-=
devel" rel=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/l=
ists/listinfo/audacity-devel</a><br>
</blockquote></div>

--0000000000004ea3b005c2bfbe7f--


--===============1870964508714869620==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============1870964508714869620==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
audacity-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/audacity-devel

--===============1870964508714869620==--