Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Unanswered: How to index memo field

    I want to build fast search engine in VB with access db.

    I have memo filed full of important data.

    How I can index memo filed , or what's the best algorithms to build index .

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    You cannot directly index a memo field ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Oct 2004
    Posts
    3
    Thanks M Owen

    I know that there is no way to build direct index, but my question is: what is the other ways, I guess to build separate table with each word in a field and its location on the second file.

    Is it good; is there another way with good performance?

    Thanks

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by abumoosa
    Thanks M Owen

    I know that there is no way to build direct index, but my question is: what is the other ways, I guess to build separate table with each word in a field and its location on the second file.

    Is it good; is there another way with good performance?

    Thanks
    Now here's the question: Why? Since you can have up to 64K (65536 bytes) in a memo filed that is a VERY large # of columns to tokenize (even taking just the "significant" words) ... And I don't think Access could handle that very well ... Any given table can have up to 255 columns in it ... Have you thought about using queries to search using the LIKE pattern matching?

    The other initial question I have is is this for something like a document center (or like that)?
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Oct 2004
    Posts
    3
    Maybe my previous post was not clear, what I mean is to loop through each memo record and split words in another table, suppose you have this text in memo filed:

    Id Memo
    --- -------
    434 How are you, thank you blah blah

    So, if I want to index it, I'll build table with this structure:

    Word Place
    ------- -------
    How 434
    Are 434
    You 434
    Thank 434
    Blah 434

    Word will be unique, so if any word in same table, I wouldn't add it again, gust add its place, finally it will be like this simple:

    Word Place
    ------- -------
    How 434,3434,44333
    Are 434,122
    You 434,345
    Thank 434,786
    Blah 434,6776,76756
    Can 3,122
    Many 444,33232

    What about that idea ???

    Thanks again

  6. #6
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    It would work ... Ungainly after many documents and many words ... Essentially you're just building a hash table ...

    Have fun.
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •