I've used Verity under 4.5x to index 60,000 odd records with no problems.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Michael
Lugassy
Sent: Thursday, 14 June, 2001 10:13 PM
To: CF-Talk
Subject: Re: Verity Limit
do you have ANY where clause in your SQL query (that the verity builds
collection on)?
maybe maxrows?
try getting the query.recordcount before creating the index - see what it
shows.
I'm using CF 4.5 Verity for over 5,000 rows, it's not alot, but it's more
then you have
so it's YOUR problem, I guess ;-)
Thanks,
Michael
----- Original Message -----
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 14, 2001 11:50 AM
Subject: Verity Limit
> I'm having a problem with a Verity collection...
>
> I have one table build with 6,800 records, this isn't fantastically big,
but
> the problem is that when I build a Verity collection on it, and then
search
> for *, it only returns 1,603 results
>
> I know that Verity in CF4.5 has it's limits, but this is just rediculous
>
> I've purged before building it, killed it and then rebuilt it... just
about
> everything I can think of
>
> Any ideas anyone?
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
