Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
How to define a full text index? |
Tue, Feb 14 2006 12:14 AM | Permanent Link |
Sam jones | Hello!
How do I define/create a full text index? I have been looking through the docs, and I must be missing something.... I looked here http://www.elevatesoft.com/dbisam4d7_full_text_indexing.htm and at the table docs, and nowhere do I see the syntax for creating a full text index, or a discussion of how / when the full text index is created.... (Discussions of performance, index size, index maintenance, etc. would be helpful as well!) Soooooooooooooo Where do I start? Thanks! |
Tue, Feb 14 2006 4:29 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sam
Easiest way to create FTI's is to use DBSys then if you want it in code just reverse engineer the table. Performance using TEXTSEARCH rather than LIKE is about on a par with the difference between using an index to locate a record and navigating through the table one record at a time and doing field=value. Index size - depends on how much text you're indexing - but think enormous and you can't go wrong Seriously the index will be large. In my app the blb is c600Mb the index c100Mb BUT only because I've set up custom functions to strip out html code and any words < 3 or >40 characters. Maintenance - the only real problem is if you define your own custom handling - this isn't recognised in DBSys (unless you add it) so any restructuring of the table, or data entry or deletion done away from your custom function will need a repair of the table with your function linked in. Roy Lambert |
Tue, Feb 14 2006 2:01 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Sam,
<< How do I define/create a full text index? >> You do so when creating or altering the structure of a table: http://www.elevatesoft.com/dbisam4d7_creating_altering_tables.htm This is noted on that page: "You must alter the structure of a table in order to change any of these parameters." However, it could use a link to the above topic. I will make sure that it is included in the next build. << (Discussions of performance, index size, index maintenance, etc. would be helpful as well!) >> It's all automatic after the full text index is created for the table. The full text index behaves just like any other index. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Feb 15 2006 12:21 AM | Permanent Link |
Sam jones | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
http://www.elevatesoft.com/dbisam4d7_creating_altering_tables.htm <<<<< Thank you! I have reviewed that page.... and I have to say that the full text index information is really sparse. I can infer, barely, what is going on. It would be very helpful to have some examples. Along the lines of: To add a full text index to the example table, we would execute the following syntax: <example syntax> This allows us to use full text queries against the X and Y columns. <See full text documentation for details of these queries> Important options for full text indexes include: <index flavor A>: <description> <index flavor B>: <description> You get the idea. Some clear docs would make this area a lot more accessible. |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |