RE: Verity Limit
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
RE: Verity Limit
What is the result if you do a SELECT COUNT (DISTINCT ID) FROM [_Temp_Search_Table]? If Verity sees duplicates for the key, it will fail on adding them to the index. dave At 09:22 AM 6/15/2001 +0100, you wrote: >> I'm thinking the key you are using isn't unique. Could you post the code >> you are using to create the collection. > >Below is the SQL used to build, add and select the database - then the >CFIndex command > >The big table is meant to be built from about 230 mini-sites, each of which >having 15-20 pages, and the main search is to jump to those mini-sites (you >get the idea) > >The table is built perfectly OK - I've opened it in Enterprise Manager and >it has 6,840 real records... > >Any ideas??? >Oh yeah, CF4.5 (latest SP) > >create table [_Temp_Search_Table] >(ID varchar(255) null, >Title varchar(255) null, >Body text null, >EventID varchar(255) null, >ConfTitle text null, >URLprefix varchar(255) null) > >insert into [_Temp_Search_Table] (ID, Title, Body, EventID, ConfTitle, >URLprefix) >select '#EventID#-'+Convert(varchar(50),ID) as ID, Title, Body , '#EventID#' >as EventID, '#ConfTitle#' as ConfTitle, '#myURLprefix#' as URLprefix >from #EventID#_Pages >where Title is not null > and not (Convert(varchar,Body) is NULL > or Convert(varchar,Body)=' ') >order by Title desc > > >select ID, Title, Body, EventID, ConfTitle, URLprefix >from [_Temp_Search_Table] >order by Convert(varchar(4096),ConfTitle) desc, Title desc > > > collection="Complete_Pages" > action="Refresh" > type="Custom" > body="ConfTitle,Title,Body,EventID" > key="ID" > title="Title" > query="fullSQL" > custom1="URLprefix" > custom2="ConfTitle"> > >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
RE: Verity Limit
Philip, Even trhough you can see 6,000+ records through the Enterprise Manager doesn't necessarily mean that your SQL is successfully pully all 6,000+ records. Try commenting out your CFINDEX and do a record count of all returned 'hits' from your database table. This is something that I've had to do before myself - and I just *knew* that my SQL was doing what it was supposed to. ;o) Judith (The Other ;o) Philip Arnold - ASP put into words: >Below is the SQL used to build, add and select the database - then the >CFIndex command > >The big table is meant to be built from about 230 mini-sites, each of which >having 15-20 pages, and the main search is to jump to those mini-sites (you >get the idea) > >The table is built perfectly OK - I've opened it in Enterprise Manager and >it has 6,840 real records... Judith Taylor ICQ: 67460562 Freelance ColdFusion Developer - Athens, OH Friends don't let friends code before coffee. ~~ 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
RE: Verity Limit
> I'm thinking the key you are using isn't unique. Could you post the code > you are using to create the collection. Below is the SQL used to build, add and select the database - then the CFIndex command The big table is meant to be built from about 230 mini-sites, each of which having 15-20 pages, and the main search is to jump to those mini-sites (you get the idea) The table is built perfectly OK - I've opened it in Enterprise Manager and it has 6,840 real records... Any ideas??? Oh yeah, CF4.5 (latest SP) create table [_Temp_Search_Table] (ID varchar(255) null, Title varchar(255) null, Body text null, EventID varchar(255) null, ConfTitle text null, URLprefix varchar(255) null) insert into [_Temp_Search_Table] (ID, Title, Body, EventID, ConfTitle, URLprefix) select '#EventID#-'+Convert(varchar(50),ID) as ID, Title, Body , '#EventID#' as EventID, '#ConfTitle#' as ConfTitle, '#myURLprefix#' as URLprefix from #EventID#_Pages where Title is not null and not (Convert(varchar,Body) is NULL or Convert(varchar,Body)=' ') order by Title desc select ID, Title, Body, EventID, ConfTitle, URLprefix from [_Temp_Search_Table] order by Convert(varchar(4096),ConfTitle) desc, Title desc 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
RE: Verity Limit
What does your query look like? Have you run it 'straight' and outputted the results of that query? Maybe you're not getting the results you think you should be getting because it's something in your query. Judith Philip Arnold - ASP put into words: > > Try adding another colum with the value "justtestingveritystuff" in each > > row, > > now re-index, with that colum in the body and/or title - now run a search > > for "justtestingveritystuff" > > > > maybe searching by "*" has it's limitation, god knows.. > > let me know if it helps - start to look intresting. > >Added a field to the query; >'justtestingveritystuff' as justtestingveritystuff > >Searched on "justtestingveritystuff" and it returned... 1,603 >rows > >I've tried searching for items which are low down in the list and they don't >come up, so it must be an issue with CFSearch Judith Taylor ICQ: 67460562 Freelance ColdFusion Developer - Athens, OH Friends don't let friends code before coffee. ~~ 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
Re: Verity Limit
I'm thinking the key you are using isn't unique. Could you post the code you are using to create the collection. dave At 10:50 AM 6/14/2001 +0100, you wrote: >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
RE: Verity Limit
> Try adding another colum with the value "justtestingveritystuff" in each > row, > now re-index, with that colum in the body and/or title - now run a search > for "justtestingveritystuff" > > maybe searching by "*" has it's limitation, god knows.. > let me know if it helps - start to look intresting. Added a field to the query; 'justtestingveritystuff' as justtestingveritystuff Searched on "justtestingveritystuff" and it returned... 1,603 rows I've tried searching for items which are low down in the list and they don't come up, so it must be an issue with CFSearch 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
RE: Verity Limit
> try using a '%' instead of a '*' % does nothing for Verity on it's own - not sure what it does with other characters... 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
RE: Verity Limit
try using a '%' instead of a '*' -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 8:55 AM To: CF-Talk Subject: Re: Verity Limit Try adding another colum with the value "justtestingveritystuff" in each row, now re-index, with that colum in the body and/or title - now run a search for "justtestingveritystuff" maybe searching by "*" has it's limitation, god knows.. let me know if it helps - start to look intresting. Thanks, Michael - Original Message - From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 14, 2001 2:35 PM Subject: RE: Verity Limit > > Disk Space? > > Maybe Quota? > > Try specifiying a diffrent path for the collection > > Here's how it's going now... > I transferred the collection from a drive which had 2Gb free to one which > had 27Gb free > > The user that CF uses has Admin privelages (at the moment), so it's allowed > full access to all drives - I've done this while I have the problem, to > ensure it's not a space issue > > I rebuilt (again, 6,840 records in the query), and again 1,603 records > returned from searching for "*" in the collection... > > 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
Re: Verity Limit
Try adding another colum with the value "justtestingveritystuff" in each row, now re-index, with that colum in the body and/or title - now run a search for "justtestingveritystuff" maybe searching by "*" has it's limitation, god knows.. let me know if it helps - start to look intresting. Thanks, Michael - Original Message - From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 14, 2001 2:35 PM Subject: RE: Verity Limit > > Disk Space? > > Maybe Quota? > > Try specifiying a diffrent path for the collection > > Here's how it's going now... > I transferred the collection from a drive which had 2Gb free to one which > had 27Gb free > > The user that CF uses has Admin privelages (at the moment), so it's allowed > full access to all drives - I've done this while I have the problem, to > ensure it's not a space issue > > I rebuilt (again, 6,840 records in the query), and again 1,603 records > returned from searching for "*" in the collection... > > 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
RE: Verity Limit
> Disk Space? > Maybe Quota? > Try specifiying a diffrent path for the collection Here's how it's going now... I transferred the collection from a drive which had 2Gb free to one which had 27Gb free The user that CF uses has Admin privelages (at the moment), so it's allowed full access to all drives - I've done this while I have the problem, to ensure it's not a space issue I rebuilt (again, 6,840 records in the query), and again 1,603 records returned from searching for "*" in the collection... 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
Re: Verity Limit
Disk Space? Maybe Quota? Try specifiying a diffrent path for the collection Thanks, Michael - Original Message - From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 14, 2001 1:25 PM 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 ;-) > > The query is a straight; > Select columns > from table > order by field1 desc > > I have debug turned on, so it displays the full 6,840 records found... > > I never use MaxRows (as I use TOP if I'm doing that sort of thing) > > 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
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 ;-) The query is a straight; Select columns from table order by field1 desc I have debug turned on, so it displays the full 6,840 records found... I never use MaxRows (as I use TOP if I'm doing that sort of thing) 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
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
