Forums: [SOLVED] Fatal error: Allowed memory size exhausted - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

[SOLVED] Fatal error: Allowed memory size exhausted Rate Topic: -----

#1 User is offline   PhpApprentice 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 6
  • Joined: 08-February 13

Posted 25 May 2018 - 02:46 PM

I have a table of nearly 600,000 records. When I click on list icon for edit or view, PHP fails in this way. I changed php.ini script memory allocation (memory_limit) from 128M to 512M and it still failed.

I have removed the user choice to edit or view records in this large table. This is ok. I can use a temporary table for the users to fill and interact with, and then post their changes with SQL code.

What I wish to know is, roughly, how many records would be a limit for a list, with option to view or edit icon functionality.

In the future I could have tables with one or two million records, so I will not fight with PHP on memory limits.
0

#2 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 15796
  • Joined: 03-February 03

Posted 25 May 2018 - 03:07 PM

This sounds strange. Edit/View pages only show a single record and total number of records in the table is irrelevant.

It probably makes sense to post it to Demo Account for investigation.
Best regards,
Sergey Kornilov
0

#3 User is offline   PhpApprentice 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 6
  • Joined: 08-February 13

Posted 25 May 2018 - 05:02 PM

Ok. Will attempt that soon.

View Postadmin, on 25 May 2018 - 09:07 AM, said:

This sounds strange. Edit/View pages only show a single record and total number of records in the table is irrelevant.

It probably makes sense to post it to Demo Account for investigation.

0

#4 User is offline   PhpApprentice 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 6
  • Joined: 08-February 13

Posted 31 May 2018 - 03:26 PM

I think the issue was a first draft of data conversion, and the unique id for all records was 0, not yet assigned. Unique id is record key. I have not done a full before and after proof, but this is likely what happened.
0

#5 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 15796
  • Joined: 03-February 03

Posted 01 June 2018 - 03:13 PM

It makes some sense now.
Best regards,
Sergey Kornilov
0

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic