Hello!
I tried to implement Tunu Samuel's
<[EMAIL PROTECTED]>
suggestion to make MySQL code use multiple parameters in VALUES clause
of
INSERT statement:
INSERT INTO table VALUES (),(),(),(),()
Now all words are inserted in the table within the single query.
This avoids much parsing overhead. According to my statistics
indexing speed became almost twice faster. I tested with Apache
documentation, it is about 120 files with 12K average size:
Original version with multiple INSERTs 14 seconds,
New version with signle INSERT 7-8 seconds.
Everybody interested in testings please find new sql.c in attachment.
Regards.
sql.c.gz
