IS
Asked
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
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
Attachments
- MSAnsweredHello,
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 - ISAnsweredyes thanks you .How to send my database My Database is 17 MB is not input Attachments
- MSAnswered
- MSAnsweredHello,
Please try to run the query after selecting your database.
```sql
ALTER TABLE `sma_purchase_items` ADD INDEX `transfer_id` (`transfer_id`);
```
and edit `getTransfersReport` of `app/controllers/admin/Reports.php` and change line 2532 & 2533 (refer to image) to
```php
->from('transfer_items')
->join('transfers', 'transfer_items.transfer_id=transfers.id', 'left')
```
Then try again and let me know the result.
Thank youAttachments - ISAnsweredthanks help
- Login to Reply