At 12:10 PM 8/9/2007, you wrote:
> > > cat your.db > /dev/null
>
> >
> > Using Windows XP. :-0
>
> Anyone know a simple Windows command line equivalent of the cat
> to dev null command above to put a file into OS cache?
Well, 'type your.db > nul' will do the same thing, though whether or not
it will remain in the cache is another question.
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?
To build the index on a 15 million row table takes 2 hours. I guy can drink
only so much coffee. <g>
Mike
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
