Log message #4203143

# At Username Text
# Sep 13th 2019, 16:33 slackebot <alexis752>
# Sep 13th 2019, 16:33 alexis752 even for the json views
# Sep 13th 2019, 16:33 alexis752 I have nothing in the apahce logs
# Sep 13th 2019, 16:31 louis Yeap, especially that i’m using DomPDF (that’s an old projet) and this engine is a bit slow and heavy for the server ^^
# Sep 13th 2019, 16:30 admad Check the webserver aka Apache logs
# Sep 13th 2019, 16:30 alexis752 i'm using apache 2.4 + php-fpm 7
# Sep 13th 2019, 16:30 slackebot <alexis752>
# Sep 13th 2019, 16:30 alexis752 I'm having a bit of trouble with the apache config, the custom errors of Cakephp doesn't work for me
# Sep 13th 2019, 16:29 alexis752 Hi guys
# Sep 13th 2019, 16:26 challgren And your not depending on the request to generate everything and deal with potential timeouts
# Sep 13th 2019, 16:25 challgren That way theres a bit of parallel processing going on
# Sep 13th 2019, 16:25 challgren I use it to generate my pdfs/zips
# Sep 13th 2019, 16:25 louis Wow that’s perfect
# Sep 13th 2019, 16:24 challgren https://sandbox.dereuromark.de/sandbox/queue-examples/scheduling
# Sep 13th 2019, 16:24 challgren Plus you can see whats been cleaned and what failed cleanup
# Sep 13th 2019, 16:23 louis I’m going to try this way ! I agree, never thought about it :expressionless: Thank you @challgren
# Sep 13th 2019, 16:22 challgren A little bit cleaner IMHO
# Sep 13th 2019, 16:22 challgren Yeah same idea except the queue handles it
# Sep 13th 2019, 16:21 louis Okay, in previous projects I was writing CakePHP shell planned with a cron task. this is why I’m looking for better solution :slightly_smiling_face:
# Sep 13th 2019, 16:20 challgren That way if the user wants to redownload it again, Im not hammering the server with another pdf creation/zip process and can quickly serve them the “cached” package
# Sep 13th 2019, 16:19 challgren Using https://github.com/dereuromark/cakephp-queue
# Sep 13th 2019, 16:19 challgren But what I do is create my pdfs/zips and then create a queue task to clean it up in an hour
# Sep 13th 2019, 16:18 challgren Nah Im just waking up so the mt dew hasnt kicked in yet
# Sep 13th 2019, 16:18 louis Should I explain in another way ?
# Sep 13th 2019, 16:18 challgren Oh probably do a queue task
# Sep 13th 2019, 16:18 louis @challgren Yeap I’m using it ;) . Sorry if my question is not well formulated
# Sep 13th 2019, 16:17 challgren @louis https://github.com/FriendsOfCake/CakePdf is awesome!
# Sep 13th 2019, 16:16 louis Hello everyone, I’m looking for advices for PDF generation. At the moment i’ve a method that saving multiple Pdf files into TMP directory (named with a uuid) adnd then I create an archive of theses Pdf. The problem is what is a good way to remove this directory after serving file to user using `response->withFile()`
# Sep 13th 2019, 16:15 ruano84 Hi guys
# Sep 13th 2019, 14:35 admad welcome
# Sep 13th 2019, 14:33 felipe.marinho Nice, thank you :pray:
# Sep 13th 2019, 14:29 admad https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
# Sep 13th 2019, 14:29 admad *storage engine
# Sep 13th 2019, 14:28 admad also if possible use 'MEMORY' engine for the temp table
# Sep 13th 2019, 14:27 felipe.marinho Awesome... a temp table and an action to match those 2 tables... I'll try this too... Thank you @admad
# Sep 13th 2019, 14:26 admad *if your
# Sep 13th 2019, 14:26 admad then do whatever processing you need
# Sep 13th 2019, 14:25 admad if you table columns don't directly match csv columns then first dump the csv in a temp table with matching columns
# Sep 13th 2019, 14:24 felipe.marinho the problem is to match the fields from the CSV and the table columns...
# Sep 13th 2019, 14:23 admad you should just upload file and use a shell / command to do the importing in background
# Sep 13th 2019, 14:23 admad ideally importing 500,000 lines of csv should be even done in a web request.