For us it was better. I don't have quantitative numbers though. It's weird 
that you are having degraded performance. When they were building CFMX 
(RedSky) Spectra was used extensively for performance testing of it due to 
the complexity. I recall Tim Buntel discussing it on this list. 

One thing I have noticed you have to watch out for is performance of 
Spectra (or any) collections. They seem to get fragmented and will degrade 
over time. I've got a script that I run nightly to optimize all of the 
collections which seems to keep things in order. If you use metadata like 
we do, collection performance is critical.

Are you using the built-in Spectra cache? If so, I'd get rid of it. Check 
out cf_supercache or Cachitron. Cf_supercache doesn't cache anything in 
designmode. Not sure about Cachitron.






[EMAIL PROTECTED] jjroman
03/22/2005 12:25 PM
Please respond to spectra-talk
 
        To:     Spectra-Talk <[email protected]>
        cc: 
        Subject:        Spectra Performance in MX

Hello

I'm migrating a spectra application from CF 4.5 to MX because I need the 
new Verity Engine for indexing documents.

But in the tests that I have done the performance in general is almost 
very bad, with execution times twice slower than in the "old" version, and 
in some pages five times slower.

My pages usually have several containers with custom rules and sometimes 
custom queries to access the objects database. In both cases the 
coldfusion MX runs more than 250 ms in many API "cfa_..." calls and with 
the loops the time increases quickly.

I have set the Coldfusion MX settings to cache all templates, increase the 
number of queries cached and so one, but with poor results. My pages are 
also cached with spectra cache but the problem remains in designmode and 
in several pages that can't be cached due frecuently updates.

So the question is for those who have migrated spectra apps to MX: How was 
your performance, without changing code and spectra cache, of your apps?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:17:5659
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/17
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:17
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.17
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to