[sqlite] Creating index takes over an hour

[mos]

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?

Mike
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------