View Product Details in Transfer Report Searching Very Slow (Please Check Transfer report) if 200 or 500 entries is ok good ( 2000 up entries ) Searching Transfer report in Product Details Very Slow
Can you check this Transfer Report ? Other Report All It is always good… only Transfer Report in Product Details
My memory_limit 4G other things very fast. Now the only thing is the problem.
max_input_vars 100000 memory_limit 4G
- MSAnswered
Hello,
It might be due to database query. Let me check it tomorrow morning. If you can backup database and attached with private reply, just need this to test with big data.
Thank you
- ISAnswered
yes thanks you .How to send my database My Database is 17 MB is not input Attachments
- MSAnswered
- MSAnswered
Hello,
Please try to run the query after selecting your database.
ALTER TABLE `sma_purchase_items` ADD INDEX `transfer_id` (`transfer_id`);and edit
getTransfersReportofapp/controllers/admin/Reports.phpand change line 2532 & 2533 (refer to image) to->from('transfer_items') ->join('transfers', 'transfer_items.transfer_id=transfers.id', 'left')Then try again and let me know the result.
Thank you
Attachments - ISAnswered
thanks help
- Login to Reply