Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 11 to 18 of 18 total |
Elevate DB |
Mon, Mar 12 2007 4:48 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< However, I see "Text search on non-indexed columns" isn't available in ElevateDB shame. I've found it a very useful feature. I hope that the alternative isn't using lots of LIKE's >> It's the same thing, essentially, except that LIKE is faster. IOW, there is no benefit to the full-text indexing without the "indexing" part. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Mar 12 2007 4:50 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << - Firefox/2.0.0.2 - Windows XP Professional >> I'm accessing it with FF 2.0.0.1 and it looks just fine. I'll try it with 2.0.0.2, but I doubt if I'll see any difference. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Mar 13 2007 3:50 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< However, I see "Text search on non-indexed columns" isn't available in >ElevateDB shame. I've found it a very useful feature. > >I hope that the alternative isn't using lots of LIKE's >> > >It's the same thing, essentially, except that LIKE is faster. IOW, there is >no benefit to the full-text indexing without the "indexing" part. But its a lot easier to generate a TEXTSEARCH for a wadge of words rather than to 1) determine wether or not this column has a text index and if not generate a load of LIKES. Just being lazy again Roy Lambert |
Tue, Mar 13 2007 6:14 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< But its a lot easier to generate a TEXTSEARCH for a wadge of words rather than to 1) determine wether or not this column has a text index and if not generate a load of LIKES. >> Actually, it's very simple. Try using CONTAINS or DOES NOT CONTAIN on a non-text-indexed column. You'll get an error. To be honest, this all goes back to the fact that the full-text searching in EDB is more closely-tied to the parameters used to build the text index. I believe this was a step forward, even though the brute-force text searching was lost in the process. It's more flexible than the old text indexing in DBISAM that was tied to the table instead of the index/column. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Mar 14 2007 4:20 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Actually, it's very simple. Try using CONTAINS or DOES NOT CONTAIN on a >non-text-indexed column. You'll get an error. What a wonderful way to do build a query from end user input. Can I tell them its your idea Roy Lambert |
Wed, Mar 14 2007 6:05 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< What a wonderful way to do build a query from end user input. Can I tell them its your idea >> Well, you shouldn't be allowing them to perform full-text searches on columns that aren't indexed. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Mar 15 2007 4:16 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< What a wonderful way to do build a query from end user input. Can I tell >them its your idea >> > >Well, you shouldn't be allowing them to perform full-text searches on >columns that aren't indexed. Oh yeah. Well in that case .... why did you build it in (score Roy 3 Tim 0) Roy Lambert |
Fri, Mar 16 2007 3:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Oh yeah. Well in that case .... why did you build it in (score Roy 3 Tim 0) >> Whoops, I just looked again and I forgot to put in the actual error when an index doesn't exist. Right now it simply returns all rows. -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |