Many thanks
great help
Seamus
At 06:59 pm 4/05/01 , you wrote:
>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
