mssql_fetch_array memory leak

[micchese]

To anyone who can help...

 

I need to import data from MSSQL database on a remote server to a local MYSQL database.

For some tables, their size is large, so I came across a problem with memory exhausted.

 

Basically I do:

 

$res = mssql_query( $sql )

$rows = mssql_num_rows( $res )

while ($rows) {

echo memory_get_usage()."\n";

$data = mssql_fetch_array( $res, MSSQL_FETCH_ASSOC);

echo memory_get_usage()."\n";

$rows--;

}

 

each mssql_fetch_array() call allocates a huge amount of data which is not freed.

I end up eating all available memory, and process never ends.

Can you suggest anything to solve this problem?

 

This behavior doesn't happen testing the same thing on a mysql driver.

Comparing php_mysql.c and php_mssql.c extensions side by side, they appear to

be similar, at least for what concern field keys creation and fields allocation.

 

Any help is greatly appreciated.

 

1009

[New Coder]

I might be totally wrong but would

 

mssql_free_result ($data);

 

Work??