SQL Server 2008 returns “Memory limit of 10240 KB exceeded for buffered query” in php

Question

I am trying to to get data from SQL server database and save to MySQL database using by php_sqlsrv. it works fine, but when I try to retrieve more than 1500 or more rows in one query it shows this message:

Error Number: IMSSP/-59 Memory limit of 10240 KB exceeded for buffered query SELECT * FROM mytable;

How can I fix this? can we fix from php xammp? or is it a sqlsrv problem?

score 1 · Accepted Answer · edited Jan 10 '18 at 08:08

1

try to adding sqlsrv.ClientBufferMaxKBSize = 10240 into your php.ini

edited Jan 10 '18 at 08:08

Rahul Gupta

9,775
7
56
69

answered Jan 10 '18 at 06:22

Hafied Mustaman

26
4

SQL Server 2008 returns “Memory limit of 10240 KB exceeded for buffered query” in php

1 Answers1