Fatal error: allowable memory size of 134217728 bytes has been exhausted (tried to allocate 3 bytes) after ini_set

Question

At first I already examined this , this and this .

I got the following error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 220 bytes)

I work with php 5.4and sql Anywhere 11.

Resolving this in accordance with

Hope someone can help me.

Solution : I found a solution: I added WHERE (columnName1 = columnName2), divided the result, and it works again, relatively quickly!

<?php
    $connect = sasql_connect("UID=username;PWD=pass");
    if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };
    $results_page = 100;
    $start_from = ($page-1) * $results_page + 1;    
    $result = sasql_query($connect, "SELECT TOP $results_page START AT $start  * 
                    FROM table1, table2 WHERE (columnName1 = columnName2)");

    if(!$result){
    echo "sasql_query failed";
    return 0;
    } else {
    echo "query completed successfully\n";
    sasql_result_all($result);
    }
    sasql_close($conn);
?>

Of course I add to my php-pagea <a href="<?php echo $page -1; ?>">Previous</a>and<a href="<?php echo $page + 1; ?>">Next</a>

Thank you all for your help!

Answer 1

You have to use

ini_set("memory_limit",-1);

"memory_set". , : fooobar.com/questions/142278/... ( Suhosin ).

script , . , , - SQL-.

, . , , LIMIT ... OFFSET SQL.

Answer 2

, php-pecl-apc , php config memory_limit 48 , .