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!