aprsworld / mybergey

0 stars 0 forks source link

Long Queries for Fault List #6

Open aprsandrew opened 8 years ago

aprsandrew commented 8 years ago

We occasionally see very long queries for the PS2Tap Fault List page, which slows the server down significantly. My best guess is that this is caused by someone setting the start/end dates to the maximum ranges on a large table with years of data as well as many fault instances.

We should probably limit the fault log queries to a given number of days. (For example a maximum 90 day span from start date to end date).