Re: transpose on bigger datasets?

[Oliver Burnett-Hall <olly burnett-hall co uk>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

On Wed, 29 Oct 2014 13:22:33 +0000
"Berntsson, Martin" <martin berntsson eon se> wrote:
> Perhaps that could be a suggestion for the next version? - I think
> there is a general need for that, and for me the 1.6x10^7 rows are
> about to run out. I don’t think there are any other software out
> there that can be used for this.

If you're dealing with datasets where you have that many rows then
you're likely to be better off using a relational database like
PostgreSQL or a statistics package like R. You'll get better
performance as they're designed to work with massive datasets and
you can constrain the types of data held in a way that isn't possible
with a spreadsheet. The cost is that they're more difficult to work
with than gnumeric.

- - olly
-----BEGIN PGP SIGNATURE-----

iQIcBAEBCgAGBQJUUS2sAAoJEMDNuTgxRltPXukP/RwwzUU8rOVRnKUSWKHnhBoO
brlVcw94YepRIGCd6CH/9/xGWhPGuj5nkQ1hYl7HkPhlpNE7/VecXV8lDxT/h1IM
gytazGmPFYvVJxUBOwSkGTRYU37XwyQlIvpGiGZHkSxn/lBucdw/aLYjlezstnml
ks1zZqH6s9bQ0V30Rf5HbOicpYbD1RXyGCh9g6w5yyHWZiH5CQIOrLnRpCrh7DTJ
PryBSi5m2WcgrRKBBZ9ZmwM5oZ+g+Ix0XvGFxrCv17qpBQ/TEbqqjqjlvuuG57AQ
riSajG8O4CZ9EumpZ2e25qzI78d+59RGHT+bOw5oc9Bn7KyE14kJ49xK5hkbMCAt
3kJZ8Ztk3plCp8MKD325WzA8lOwOuL88MwTAgZ47AK25z4l56YAzTQHIEBP27+oH
GXUAqNxCl6/DQBgii3gMv9sYnqpcabgCuOQH6DIZmDrmPxzpEkJ/4Fbfspy6V8vb
Ek+kD6Tf1gcYZM9EwI40JwLxFgOE4TgfxiD4avifOLpqcKRJHqQcdwW8PFmz0k7y
SsEaayOiCqG+XJnOrZocpZea/H9DtvnUxf19+aXGsHhQ997x99uVlQkKmWvqEJQa
WJ6UMdrNpe9/Aq+ICIYfPJKMk0ZjvVLKr1h20E80/HZafMSLNy7PyPZo111X8aQB
htUWxjU/Dm3cjqTQRtmx
=BeH3
-----END PGP SIGNATURE-----