[Phpmyadmin-devel] PHPExcel 1.7.6

[Dieter Adriaenssens]

2011/3/2 Marc Delisle <marc at infomarc.info>:
> Le 2011-03-01 13:05, Dieter Adriaenssens a écrit :
>> 2011/3/1 Michal Čihař <michal at cihar.com>:
>>> Hi
>>>
>>> Dne Mon, 28 Feb 2011 19:18:10 +0100
>>> Dieter Adriaenssens <dieter.adriaenssens at 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



-- 
Groetjes,

Dieter Adriaenssens