--- mos <[EMAIL PROTECTED]> wrote: > Is there no way to allocate more memory to SQLite index buffers like you > can with MySQL and most other databases? I suspect SQLite is building the > index on disk which will be 100x slower than if it used RAM. The indexing > process has used 400MB of RAM so far and it seems not to want any more even > though there is 800mb free. I could go out and get more RAM, but if SQLite > doesn't use it, what's the point?
see the previously mentioned pragma statements: http://www.mail-archive.com/sqlite-users%40sqlite.org/msg26838.html Don't discount the speed increase of OS file caching (pre-caching). It can make a very big difference. > > To build the index on a 15 million row table takes 2 hours. I guy can drink > only so much coffee. <g> ____________________________________________________________________________________ Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. http://tv.yahoo.com/collections/222 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------