Skip Navigation

[Resolved] Getting Allowed memory size exhausted message after importing large number of posts

This support ticket is created 4 years, 5 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Karachi (GMT+05:00)

This topic contains 3 replies, has 2 voices.

Last updated by Waqar 4 years, 5 months ago.

Assisted by: Waqar.

Author
Posts
#1712373

i am using toolset types and views ,

The plugin was working fine but i have 110000 Post hat i imported to my site (large data) .

my view suddenly stopped working , i am using search filter to search throw my view . i get this error
Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) in /home/esdfdemo/public_html/wp-includes/wp-db.php on line 1989
i've increased the memory to 512MB
but i still have the same issue !!

This is my live site link where my view is, hidden link
this is my link to view hidden link after importing all these data

#1712413

Hey
The build can't continue because the total size of files and the database exceeds the 500MB limit that can be processed when creating a DupArchive package.
Can i just give you a user to the site?

#1712467

Hi,

Yes, I've set your next reply as private and you're welcome to share temporary admin login details.

I'll try to create and download a limited duplicator package, on my own.

regards,
Waqar

#1713591

Hi,

Thank you for sharing the admin access.

It seems that the exceptionally large database size or the server's security settings are not letting the Duplicator package to complete the scanning process for the duplicator package creation.

I did however noticed that your view "المحفظة" on that page is set to show all the "الحافظة" posts which are 108,360 in total.

Have you considered using the pagination or infinite scrolling feature, so that not all the posts are queried from the databased at once?
( screenshot: hidden link )

This will not only help you avoid the "out of memory" messages, but it would also provide your visitors with a more streamlined experience and improved loading times.

regards,
Waqar