Have you optimized your collections lately? If you have 'busy' collections,
ie, they get updated quite a bit, it's a good idea to optimize your
collections daily. I saw this have a _dramatic_ effect at one of my client
sites.
=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Michiel Boland [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 02, 2001 11:55 AM
> To: Spectra-Talk
> Subject: cfindex troubles
>
>
> Hi. I am currently having a problem with CFINDEX being really slow on
> a spectra server running CF4.5.1SP2 on WIN2k. And by really slow I do mean
> *really* slow. A CFINDEX of a 19 row query in two collections takes about
> 285860 seconds. Has anyone else seen this?
>
> --
> Michiel Boland <[EMAIL PROTECTED]>
> Digital Valley Internet Professionals
> Plantsoen 17, Wageningen, The Netherlands
> Phone: +31 317 465555, Fax: +31 317 460276
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
