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

Question

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

score 2 · Accepted Answer · answered Aug 18 '18 at 16:43

2

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

answered Aug 18 '18 at 16:43

Hidayat Ullah

147
9

1

Try this in your code `ini_set('memory_limit','256M'); ini_set('sqlsrv.ClientBufferMaxKBSize','524288'); ini_set('pdo_sqlsrv.client_buffer_max_kb_size','524288');` – Hidayat Ullah Aug 18 '18 at 16:56
it's working, but the only problem is my browser being not responding, do you have any suggestion to show 36000+ row, in select option? – Andy Setiawan Aug 18 '18 at 17:06
Sorry, i don't get what do you mean by select option are you mean html select option. – Hidayat Ullah Aug 18 '18 at 17:08
Do pagination if your rows are too much it doesn't make sense to show it on one page. – Hidayat Ullah Aug 18 '18 at 17:12
yap, i mean HTML select option, so i get the value from database, but the row data have like 36000.data – Andy Setiawan Aug 18 '18 at 17:15
how to make select option use pagination? – Andy Setiawan Aug 18 '18 at 17:16
You know about pagination? – Hidayat Ullah Aug 18 '18 at 17:17
yeah, i know about pagination. but do you know about select option? in html? – Andy Setiawan Aug 18 '18 at 17:25
why are you not using pagination?As far the select option is concern it can also be handle with that. – Hidayat Ullah Aug 18 '18 at 17:27
can you give me an example the code of select option using pagination? – Andy Setiawan Aug 18 '18 at 17:31
pagination don't need select option. – Hidayat Ullah Aug 18 '18 at 17:37
pagination don't need select option. – Hidayat Ullah Aug 18 '18 at 17:37
i use select option for fill the form purpose. – Andy Setiawan Aug 18 '18 at 17:39
I would suggest a auto complete select that limits the query, yes I've used this solution myself for selects that errored from memory – Barry Aug 18 '18 at 17:43

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

1 Answers1

Linked