Error deleting 25 records out of 10,100

Post Reply
weitau
Posts: 38
Joined: 08 Aug 2020, 10:27
Name: Robert T
Location: New York, USA

Error deleting 25 records out of 10,100

Post by weitau »

When I select 25 records out from the Tasks table containing over 10,000 records, my session crashed.

https://www.loom.com/share/fdf2bcc24ecf ... b223384c47

Log is attached
Attachments
Errors_Sep_2020.txt
(170 Bytes) Downloaded 94 times
db_log.txt
(60.67 KiB) Downloaded 86 times
User avatar
support
Site Admin
Posts: 6222
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error deleting 25 records out of 10,100

Post by support »

Open config/server.php and find option

Code: Select all

define('STORE_SESSIONS', 'mysql');
Remove mysql and php will use default session handler. It should help.
weitau
Posts: 38
Joined: 08 Aug 2020, 10:27
Name: Robert T
Location: New York, USA

Re: Error deleting 25 records out of 10,100

Post by weitau »

Yes, this worked! Thank you Sergey!

I selected the Check all box, and I deleted all 10,000 records. Not what I was intending, but the database performance was pretty darn good!

There is no option to set the check all to only be the 25 records on the page, no?
Post Reply