CODEWITHSUNDEEP
php
Andy Setiawan
Andy Setiawan

Reputation: 35

How solve row query with a lot of value, Memory limit of 10240 KB exceeded for buffered query

i have 67508 data row, and i have error like this, how to solve this?

the error like this :

A Database Error Occurred

Error Number: IMSSP/-59

Memory limit of 10240 KB exceeded for buffered query

Upvotes: 2

Views: 5746

Answers (1)

Hidayat Ullah
Hidayat Ullah

Reputation: 157

Add the following lines to your php.ini.

extension=php_pdo_sqlsrv_55_ts.dll
extension=php_sqlsrv_55_ts.dll
client_buffer_max_kb_size = '50240'
sqlsrv.ClientBufferMaxKBSize = 50240

Upvotes: 3

Related Questions