![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 11 to 18 of 18 total |
![]() |
Mon, Mar 12 2007 4:48 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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. ![]() | << - 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 ![]() | 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. ![]() | 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 ![]() | 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. ![]() | 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 ![]() | 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. ![]() | 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 Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |