search

afs1jes / Clarins-US-IR-Migration

0 stars 0 forks source link

System times out when trying to drill down into transaction detail #106

Open AVHuntley opened 1 year ago

AVHuntley commented 1 year ago

I agree, I'm seeing this timeout occur as well. Looking into it now.

AVHuntley commented 1 year ago

So we did some stuff to the database behind the scenes that seems to have helped a lot. In my own brief testing, I'm now able to drill without timing out. And working with transactions should be much faster (the server suggests up to 98% faster, but we'll see).

Can you keep poking around and let us know if things seem better to you as well?

(The technical explanation is that we created an index on the Transactions table. This allows the system to find information much more quickly.)