Information générale
Titre:
Help - SQL Select is taking forever
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement