Question
CF8 first query on page slow
We recently switched from CF7 to CF8 and one of the things we
noticed was the first query (and only the first query) on our site
using CF8 is extremely slow compared to how long took on CF7.
It is a simple query (i.e. select * from table where tableid=1). The table is indexed and it is still taking between 90-200ms to complete. We switched back to CF7 to compare and the query runs between 0 and 16ms everytime.
Our environment is Window Server 2003 running Apache 2.2.6, ColdFusion 8, Microsoft SQL Server 2005. I was just wondering if anyone else has noticed this and if there are any suggestions as to how to increase performance. It is adding that 100-200ms on the total page load time (according to Debugging).
Thanks!
It is a simple query (i.e. select * from table where tableid=1). The table is indexed and it is still taking between 90-200ms to complete. We switched back to CF7 to compare and the query runs between 0 and 16ms everytime.
Our environment is Window Server 2003 running Apache 2.2.6, ColdFusion 8, Microsoft SQL Server 2005. I was just wondering if anyone else has noticed this and if there are any suggestions as to how to increase performance. It is adding that 100-200ms on the total page load time (according to Debugging).
Thanks!
AdChoices