This topic is locked

Calander Template

12/3/2007 4:45:57 PM
Calendar Template general questions
B
bleckron author

I have converted our office calender from a calender Nugget created with DMX Extensions for Dreamweaver to the new ASPRunner Pro calender Template. Everything looks fine but when I click on any of the views that run through the Daily union query the page times out and I never get the view. I noticed when I run the query in Access that it takes a while to process the records before the procedure completes. Is there a work around for this so that we can run this in the page and not in the database to make it run quicker if possible. Either that or build the query in a different way. Love the template, just trying to figure a way around tyis issue.
Best Regards,
Brad <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=6966&image=1&table=forumtopics' class='bbc_emoticon' alt=';)' />

B
bleckron author 12/3/2007

I made an adjustment to the qryDaily Query. In the UNION ALL Statement under the WHERE Clause I added AND Calendar.[DateField] >= Date()-31. This limited the number of records returned and stopped the page from timing out. It now only returns 109 records instead of over 21,000. I =t limits to the last 30 days but seems to work for now. Let me know if you have a better work around.
Brad

admin 12/5/2007

If you modify SQL query this way recurrent events will stop working.
Post your application to demo account and send me the URL so I can see what makes your query run slow.