<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>From my perspective, one needs to learn how to create a database
in Base including tables, queries, forms and report when working
with this much data. It is designed to handle large amounts of it.
MySQL, Postgresql, and Oracle can be used as a backend for Base
being the front end.</p>
<p>Dan<br>
</p>
<div class="moz-cite-prefix">On 10/6/20 12:09, Noel Grandin wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAFYHVnUWC+Aj3JJBx4OGN0Zse+Ntd7iOV8+ayvbOC1Xb7VHxnA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div class="gmail_default" style="font-family:tahoma,sans-serif">Hi</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">i.e.
very large spreadsheets of up to 16 million rows.</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">So
I did some more investigation into this. In various places, we
need to accumulate things like row-heights and other things,
numbers which, with jumbo sheets, easily exceed 32-bits.</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">HOWEVER</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">All
over the place, we pass these values through
sal_uLong/sal_Long/long/unsigned long.</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">Which
is 32-bits on Windows. Doh!</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">Honestly,
the only solution I can think of (and one I confidently expect
us to reject), is that we declare a flag day, and search and
replace sal_Long/sal_uLong/long/unsigned long with a 64-bit
type across the ENTIRE code base.</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">Regards,
Noel Grandin.</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
LibreOffice mailing list
<a class="moz-txt-link-abbreviated" href="mailto:LibreOffice@lists.freedesktop.org">LibreOffice@lists.freedesktop.org</a>
<a class="moz-txt-link-freetext" href="https://lists.freedesktop.org/mailman/listinfo/libreoffice">https://lists.freedesktop.org/mailman/listinfo/libreoffice</a>
</pre>
</blockquote>
</body>
</html>