Hosting Side Slow

["... you mean these fans?"]

Hi,

 

I built a calendar for a client and initially the calendar was slow on the local computer, so I change the calendar to use ExecuteSQL "SELECT".

 

And now the calendar is super fast on the local machine.  Not even a blink and the calendar data is loaded.

 

However, the data file also sits on a Shared Server and the calendar is now insanely slow.  Over 30 seconds to display the calendar date.

 

I replace the "From" Table Occurrence to a Table Occurrence that only allows for records to list within a date range rather than the entire table occurrence, but that had no effect.  I would have thought that hence less records to query, the quicker but Nope!  the time it take to load the calendar didn't change

 

Can anybody provide some insight as to what might cause the calendar to load so slow from the hosted server.

 

Thank you.

 

Tom :-)