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 --- 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] -----------------------------------------------------------------------------
