Not sure if this would apply to your case, but what I do in a situation
like that is to create a custom field with the information that you want
displayed.. and add that to the verity index ..for example,
<cfoutput query="listAll">
<cfset title2 = title & ' - ' & dateformat(pubdate,"mmmm yyyy")>
<cfset key = serverpath &'PM\'&Filename>
<cfset display = 'uthorlname & ' , '& authorfname
<cfindex action="UPDATE" collection="podPM" key="#key#" type="FILE"
title="#title2#" custom1="display" custom2="#ID#">
</cfoutput>
then when you run your search on the verity collection, just display the
custom1 field.... this avoids the trip back to the database..
Al
>We have an interesting verity search/SQL search issue and I was
>wondering if anyone has any hints on how this possibly could be sped
>up..
>
>Ok.. some background..
>
>The Keyword search is done in verity and its fast by itself..
>
>The other searches are fast and are regular SQL.. when they are both
>combined they take a long time..
>
>Here's what happens..
>
>The Verity search returns the Keys which are equal to the ID field in
>the SQL DB.. if the keyword field is not blank then it add the keys in
>to the main query example query..
>
>--
>SELECT EPSTable.posting_date, agency_, office_, classcod_, subject_,
>solnbr_, epsid,
>(select top 1 par_id from par where
>rfpnumber=replace(epstable.solnbr_,'-','') and (rfpnumber is not null or
>rfpnumber<>'' or rfpnumber<>'N/A')) parid
>FROM EPSTable
>WHERE
>(1 = 1)
>AND EPSTable.epsid IN
>(13913,11967,15428,15407,15057,15036,18538,14881,19636,18330,9411,16568,
>7593,19812,19391,17230,16774,10795,13469,6393,11616,11293,18112,16529,15
>461,15090,13871,11925,10778,9032,17558,16233,13893,13310,13069,11947,107
>79,9771,8907,7441,2676,16772,12398,10547,7974,5239,4158,20497,20400,2039
>9,20051,19996,19804,19640,19610,19299,18582,18300,18299,18291,18258,1812
>3,18075,17862,17738,17111,17026,17014,16993,16982,16846)
>
>AND CLASSCOD_ = '10'
>ORDER BY POSTING_DATE
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
