Wendy, The schema for the smpolicy database is different in CF5 then it is with cf 4.5. I assume you have a CF5 policy database running with CF4.5. If you don't then this could be a part of your problem.
Check your query execution times between both systems to rule that out. I would also suggest to everyone that you run the CFMX 6.1 updater on your staging server first... test for any bugs... then put into production. -Kurt. -----Original Message----- From: Wendy Copley [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:39 PM To: Spectra-Talk Subject: Spectra 1.5.2/CFMX successes? Hi all! I've been working with Marc Straka (who has been posting problems to this list for the past couple months) on an upgrade from Spectra 1.5.1/CF 4.5 to Spectra 1.5.2/CFMX. We have two versions of our site up and running now -- one version on the old environment and one with the new. After a number of problems, things were going pretty well for us with the new environment until we put the box into production. When we did side by side comparisons of the two boxes running the two different versions, we discovered that it is significantly slower than our old version of the site -- roughly 5-10 times slower. The hardware for the two boxes is identical and the load on the two boxes was pretty much equivalent. We are still in the process of trouble-shooting this, but we're wondering now if our problem is unique. How many other people out there have successfully upgraded to Spectra 1.5.2 with CFMX? Have you noticed a speed increase or is it about the same as it was pre-upgrade? Thanks! _______________ Wendy Copley Web Engineer Nolo [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| In the beginning ColdFusion shipped with Website. Both have only gotten better http://www.deerfield.com/products/website/ Message: http://www.houseoffusion.com/lists.cfm?link=i:17:5465 Archives: http://www.houseoffusion.com/lists.cfm?link=t:17 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:17 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
