Hi,
We ran into a very frustrating problem today that made my doubts in Spectra really
strong and the CF world dim...
The problem is basically an enormous SLM size. The number of Spectra pages on our site
had reached nearly a thousand and a total number of containers is around a 3.000.
Perfomance had drastically degraded once we reached this number of objects in SLM.
Spectra is loading the whole Site Layout Model in the server scope every time a CF
server is started. This takes somehting like 200 Mb of RAM and what is really
frustrating up to 5-7 minutes of time.
Moreover, if two or more people happen to access the CF server at the same time when
it's starting, CF just locks up and initialization process takes up to 20 minutes!
Have a suspicion this is also due to some slappy Locking errors, which are there in
Spectra custom pages.... (e.g. CF_PAGE).
This particulat SLM problem WAS addressed by some people before (this November Nicole
Ruschmaritsch ([EMAIL PROTECTED]),
http://forums.allaire.com/spectraconf/Thread.cfm?&&Message_ID=616280&_#Message616280 )
in the Allaire Spectra discussion forum, as well as lockig issues in CFA_PAGE. But
her posting was basically ignored by Allaire, with only some suggestions from people
on the side to decrease a total number of pages.
In Nicole's case it was something like 7.500 pages. In our case I am talking about a
considerably smaller ammount of pages, less than a 1000... Yes, we can decrease a
number of pages and go down to something like 200, BUT in this case most of the
container contents cannot be cached :( Since, we'll be putting, so much stuff into the
same containers....
Did anyone have a similar problem? Is there anyway not to load the SLM at startup
(CFA_APPLICATIONINITIALIZE)? We can call containers directly by UUIDs, so i can
imagine some kind of a work around can be done in the front, but for the back end???
We are running CF 4.5 SP2 on a testing machine with 512Mb 600 Mhz, Win2000, SQL 7.0,
Spectra 1.5 with all the possible fixes apllied and recent MDAC drivers in place....
Please, advise on how to procede...
roman
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
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.
