Website -Route Assignment Page

JRW1585 · Post by **JRW1585** » Tue Jun 05, 2007 4:25 pm

"I'm having issues with the route assignment page. I have tried to display it in both Firefox and IE, but it hangs and never displays any data. Most of the php menus are then screwed up. Anyone have any idea why this could be happening? Jeff 1585"

Post by **thansson** » Tue Jun 05, 2007 5:46 pm

"It's the connection between the website and the database that sometimes takes too long and causes the page to time out. It happens on the pages where we do long and complicated queries and the Route Assignment page is definitely one of them. I will see what I can do to optimize it. I am not much of a database wizard so this may take a little while... In the meantime, a refresh or two usually will fix the problem. If not, then wait an hour and try again - hopefully the database has woken up by then. I have had many conversations about the database connectivity issue with the ISP and it is about as good now as we can hope for..."

Post by **thansson** » Tue Jun 05, 2007 7:01 pm

"Well, I couldn't get the query to speed up too much but the main issue is that we keep all the route assignment for 12 months before they get overwritten by the current month. So when I deleted the "old" assignments, everything sped up a LOT. Now, hopefully I didn't delete something that we needed.

(I do have a backup just in case)"

JRW1585 · Post by **JRW1585** » Wed Jun 06, 2007 8:37 am

"Thanks for taking the time to review and make some adjustments. Thanks for being so quick to respond and one more thanks for your help, time, and dedication to our wonderful hobby here.

"