>Hi. I hope someone can shed some light on a strangeness.
>
>As part of my client's day-end proceedure there is an sql select which select data from two large and one small (~70,000, 2,900,000 and 1 record(s)). Up until a few days ago this ran fine, but three days ago it started to take a VERY long time (after 8 hours it was 13% done) I've tried PACKing the tables but that didn't make any difference.
>I will be very grateful for any suggestions as to what could be causing this, and what I can do about it. I am using FPW 2.6
If all was OK in Fox and no indexes have been dropped/altered, maybe it's a hardware issue. Is the disk getting full, maybe it needs a defrag. Maybe something else is hitting the network hard and slowing data transfer speed (if the data is accessed across a network)?