--- Juri Wichanow <[EMAIL PROTECTED]> wrote: > > In my database of 30 000 000 records. > > At " Pragma cache_size = 1000000 " indexation lasts > 12 hours, > > at " Pragma cache_size = 2000 " - 45 minutes.
It would be interesting if you ran a profiler such as gprof during each run to see where the time is spent and post the results. ____________________________________________________________________________________Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. http://mobile.yahoo.com/go?refer=1GNXIC ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------