At 10:19 AM 8/9/2007, you wrote:
If your database file is less than the size of your RAM,
then do this before the create index to speed it up:
cat your.db > /dev/null
See also:
PRAGMA cache_size = number-of-pages;
and
PRAGMA page_size = bytes; -- recommend at least 8192
http://www.sqlite.org/pragma.html
Using Windows XP. :-0
Mike
--- mos <[EMAIL PROTECTED]> wrote:
> I'm building my first index on a large table using the "Create index
> ix_Main on Table1(StringField1,StringField2,DateField,TimeField)" and so
> far it has been running over an hour on a fast computer with 2gb ram.
There
> are 15 million rows in the table. The same index can be built in MySQL
in a
> minute or two. Why does it take so long?
____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all
the tools to get online.
http://smallbusiness.yahoo.com/webhosting
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
