Export of 37000 record table

Issue #78 resolved
Former user created an issue

Originally reported on Google Code with ID 78

What steps will reproduce the problem?
1. Click export on 37000 record database

What is the expected output? What do you see instead?
Broswer error message - page not found

What version of the product are you using? On what operating system?

Please provide any additional information below.

Export of 37000 record table fails. 12000 record table in same database works okay

Reported by michael.d.hornsby on 2012-01-07 08:30:28

Comments (9)

  1. Dane Iracleous
    Are you sure you aren't getting a PHP timeout error? Like "x amount of y memory exhausted"?
    In any case, you should increase your memory and maximum execution time settings in
    php.ini. phpLiteAdmin should be able to export that many records, but your PHP configuration
    might be preventing it.

    Reported by diracleo on 2012-10-29 06:10:27

  2. dreadnaut
    This might also be because the database object returns an array of arrays (Database::selectArray,
    line ~920) trying to allocate memory for the whole table of results.
    We could return an iterable object, instead, and we should not hit memory limits.

    Reported by dreadnaut on 2012-11-22 19:30:06

  3. Christopher Kramer
    Yeah, right. Loading thousands of rows into memory seems to be a bad idea and likely
    the root cause for this problem.

    Reported by crazy4chrissi on 2012-11-22 22:42:46 - Status changed: Accepted

  4. Kevin Wojniak

    I'm running into this same issue. Have a table with 39k rows.

    PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 78 bytes) in phpliteadmin.php on line 5417
  5. phpLiteAdmin repo owner

    Export (CSV and SQL) of huge tables is now possible because the export won't fetch the whole table in memory anymore but iterate over the resultset. This fixes issue #78.

    → <<cset 6947ecc44da1>>

  6. Log in to comment