Developer forum

Forum » Rapido » Invoices list request timed out

Invoices list request timed out

E-mail notifications
Fabio Monte
Reply
Posted on 12/10/2020 16:10:52

Hello

We are running into performance issues while loading the invoices list. This happens with a customer with over 70000 ledgers and altough we set a paging of just 1 item per page, it still times out.

Shouldn't it retrieve one result even though there will be thousand of pages?  

InvoicesList.PNG

Replies

 
Nicolai Pedersen
Posted on 20/10/2020 09:41:53
Reply

Hi Fabio

Yes, that is a problematic setup. This feature is from where we only listed data of orders made on the platform.

DW actually queries all orders for the customer and then pages in memory, so that will not work with this many items.

So - we will add a feature to used a paged SQL query as it should be.

You should then also have a look at the database indexes on this table if you will have this many records for each customer. Ensure the table has an index that supports the query used on this page.

BR Nicolai

 

You must be logged in to post in the forum