2011/3/2 Marc Delisle marc@infomarc.info:

Le 2011-03-01 13:05, Dieter Adriaenssens a écrit :

...

2011/3/1 Michal Čihař michal@cihar.com:

...

Hi

Dne Mon, 28 Feb 2011 19:18:10 +0100 Dieter Adriaenssens dieter.adriaenssens@gmail.com napsal(a):

...

An update for the PHPExcel (1.7.6) library was released yesterday.

Are there any fixes which look important to us?

They claim improvements in memory usage when creating an Excel-file, but I didn't test it yet.

I remember seeing reports about excessive memory usage for phpMyAdmin users when exporting with this, so please test it, for 3.4.

There are some improvements. I quickly tested with a small dataset (two tables, one containing approx. 15 rows, another approx. 700 rows, total size of both tables : 20 KiB):

PHPExcel | 1.7.4     | 1.7.6 XLS            |  26 MB | 23 MB XLSX          | 32 MB  | 23 MB

Not a significant improvement, and the export still runs out of memory with a slightly larger, but not huge, dataset (800 KiB, needs at least 130 MB of memory, but then runs out of it). I still wonder why exporting 20 KiB of data needs that much memory.

For reference, when exporting the same dataset as SQL :

|   sql         |  bz2 small set (20 KiB)    |   10 MB   |  18MB larger set (800 KiB) |  19 MB    |  24 MB

BTW: The memory sizes are that of the apache instance, so it is about 10MB to start with.

But maybe the way we are using the library can be improved as well. I'll look into that if I find some time, but maybe that's something for 3.5-dev? I think we can reduce the size of the PHPExcel library as well, we certainly don't use everything in the library.

Greets,

Dieter

...

And some bugfixes, but nothing special.

...

...

Shall I update it in phpMyAdmin? If yes, only in master/3.4-dev, or also in QA_3_3?

Definitely not in 3.3, I'm also hesitating about 3.4, because it might break more things than it fixes.

-- Marc Delisle http://infomarc.info

-- Groetjes,

Dieter Adriaenssens