Results 1 to 1 of 1

Thread: create index -> replace text and insert records SPEED?!

  1. #1

    Thread Starter
    Addicted Member c@lle's Avatar
    Join Date
    Oct 1999
    Location
    Belgium
    Posts
    179

    create index -> replace text and insert records SPEED?!

    hello,
    i want to SPEED UP the creation of my index.

    what i'm doing is looping thru a database of articles, checking all the textfields and store every single word in my index database.
    this index database consists of tables like 'language_tablename_startingletter' giving me e.g. 'nl_word_a' and 'nl_word_b' and 'nl_word_c' ...

    then i open the database, get the text, do a split on spaces and parse this array by inserting first the words in the correct table (thus words starting with 'a' I insert in the table nl_word_a ...) and then inserting the link between the article and the word table.

    this proces takes a long time.
    are there other ways to create this index, or to speed up things?

    i'm looking for your answers!
    Last edited by c@lle; Apr 18th, 2003 at 01:54 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width