>> Index -D is working 7-8 hours:( Is it normal??? > >It may or may not be normal, depending on other factors, such as RAM >size, disks speed, CPU number and speed etc.
When database was near 500.000 documents, index -D works ~2 hours. And then smth happened... To increase speed of index -S I had been added KEY to the table "urlword" on field status, but I think it can only slow insert/delete queries, and index -D I think only make selects.... > > In database there are 700.000 documents. How can I increase speed? > >Increase MySQL's key_buffer_size to 1/4 of available RAM. Add more RAM. >Run OPTIMIZE TABLE on all MySQL's tables in aspseek's database. Thank you, I'll try.
