What's more, the internal object cache inside spectra is set to only hold
1000 items, that includes all the webtop, so if you've got a large amount of
items, there's going to be a lot of thrashing as objects get swapped out of
memory. The algorithm that chooses a victim object is quite slow, and
that's why it's going to take a long time to load 1000 items.
Check out the file:
program
files\allaire\spectra\customtags\system\tier0\objectstore\cfa_contentobjectc
achewrite.cfm
if you've got a large amount of objects, and a LOT of memory you may want to
change the lines :
<cfset POOL_MAX_SIZE = 1000>
<cfset POOL_MIN_SIZE = 700>
to better values. Remember that since the object id is unique, Spectra
stores all it's objects in the SAME pool regardles of the CODB.
<< David Maddison >>
wildfusion
-- The Spectra Specialists --
W: http://www.wildfusion.com
E: [EMAIL PROTECTED]
M: +44 (7747) 024455
YahooIM: maddisondavid
>> -----Original Message-----
>> From: Daniel Niklasson [mailto:[EMAIL PROTECTED]]
>> Sent: 14 March 2001 11:07
>> To: Spectra-Talk
>> Subject: RE: General Search Performance question...
>>
>>
>> > I'm doing some testing with senmi-large (8000 items)
>> verity collections
>> > right now. Verity searches are very fast when whatever
>> you want to search
>> > for is not present in the collection. Unfortunately if
>> there are matches
>> > the search can take a very large amount of time. I am
>> seeing anything
>> > between 0 and 16 seconds over here.
>>
>> Verity searches are very fast. The reason that it takes a
>> lot of time must be that when you do a verity search with
>> a Spectra-tag like "cfa_allTypeSearch" it executes the
>> search and for every match it get it does a
>> cfa_contentObjectGet to get the data for the object. This
>> means that if you get 1000 answers from your verity-search
>> it would then do 1000 sql-questions to the database and
>> that takes some time.
>>
>> --------------------------------------------
>> Daniel Niklasson Resco Väst
>> Programmerare / Sysadmin
>>
>> Tel: 031-7439203, Mobil: 0708-903238
>>
>> Unix *is* user-friendly - It´s just selective who it´s
>> friends are.
>> --------------------------------------------
>>
>> �"nnu en Rescoproduktion på webben - Telias nya startsida!
>> Titta på www.startsidan.telia.se och njut av möjligheterna.
>>
>>
>>
>>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
