The key only needs to be unique. Be that a unique path or a unique number I am not sure whether that matters speed wise. Using QueryAddRow() is a great method to combine database and file content in a collection and I haven't found it to rum *much slower. Certainly not ten times slower.
Is it just the indexing that takes longer or does the search suffer as well?. Are you using CFHTTP or CFDIRECTORY to get the file content? > I have several verity collections that index database records. It was > behaving fine before when I indexed these collections. I have altered my > code some, and it now indexes about twice as many pages, but takes at > least 10x as long to execute. The only significant changes that I made > are 1) I am adding rows to the query using QueryAddRow(), and 2) I changed > they Key that is used from a numeric identity to a mixed number/text > combination. Is it important that the key is an integer? > > TIA > > - Ben Morris > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup 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
