Wow! That is quite big - assuming an MS Access database.
Your main problem appears to be generating the index itself. Even once off
it is taxing system resources big time.
Straightaway you could do one of several things:
1 - purge the collection before updationg it
2 - if on the same box defragment the HDD before re-indexing the collection
3 - if your development box has more grunt than the actual server - consider
building the index on you dev box and then transferring it to the server.
Not ideal but it works.
For a db of 70,000 records (Access) a server would preferably need about
256Mb to generate the index and not crash - 512Mb would be better. Later
version of CF (5.0 with the new Verity) may be much better however.
-----Original Message-----
From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
Sent: Friday, 4 May 2001 18:10
To: CF-Talk
Subject: RE: verity error
Thanks
Yes about 70,000 records actually
Are there any workarounds?
The ISP originally had set Limit simultaneous requests to 1
but has since chamged this to 4
Than I got this error
The requested URL could not be retrieved
While trying to retrieve the URL: [no URL]
The following error was encountered:
� Read Timeout
The system returned:
[No Error]
I'm not sure what this means??
Thanks
Seamus
At 05:52 pm 4/05/01 , you wrote:
>Is it a relatively large collection? (eg: 60,000 individual database
>records).
>
>Verity as supplied with CF 4.x seems to be very memory and processor
>resource intensive.
>
>-----Original Message-----
>From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
>Sent: Friday, 4 May 2001 16:07
>To: CF-Talk
>Subject: verity error
>
>
>Hi
>I get this error on my ISP's server when I update a verity collection
>I do NOT get it when I do it on my home server
>Any clues - I'm desperate to find some reason for this
>
>Error Occurred While Processing Request
> > Error Diagnostic InformationRequest canceled or ignored by
> > serverServer busy or unable to fulfill request. The server is unable
> > to fulfill your request due to extremely high traffic or an
> > unexpected internal error. Please attempt your request again (if you
> > are repeatedly unsuccessful you should notify the site
> > administrator). (Location Code: 26)
> > Please inform the site administrator that this error has occurred (be
> > sure to include the contents of this page in your message to the
> > administrator).
>
>MTIA
>
>Seamus
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
