[Riaz Uddin Masum]

Hi there.

 

i was working on a project. it is huge..... it has 15,572,535 row. now when i try to run it it give me this "MySQL client ran out of memory" error. when i try with small data table it work fine. 

 

i use php.ini to override some setting below but not working

 

memory_limit=200M

upload_max_filesize=200M

post_max_size=200M

max_input_time=3600

max_execution_time=3600

"

 

can anybody help.

[Amit Shah]

well. i will 1stly suggest not to use datatables as a theme. Cuz that will try to pull up maximum amount of data.

Other - u need to configure your database server environment accordingly to be able to manage the data. There it needs specialization for that. You can either connect with someone who can or hire on contract to someone with appropriate knowledge who can help you get results better.

[Riaz Uddin Masum]

Thanks.. lets see what can i do.