I am new to sqlite. I have done some reading up. I have a table that I am having difficulty creating an index on. The table holds ~180 million rows, simple four column, integer schema. It is taking up about 1.5 gigs of space. I inherited this application and it is slowing down. The table has a primary key using the three columns, but delete and inserts are slow. I can't afford to lock up the production table to create the index so I am running some off line tests. I have a copy of the database, and I was able to create an index on each column in about 2.5 hours. Inserts and deleted improved dramatically. So I attempted the creation of the index off hours on the production system, and after 4 hours no index. I can't detect any activity at all. The journal file and the .db file just sit at the same size for 4 hours. Why is this failing? It seems like it is just sitting there doing nothing. When I created the test index, I noticed the journal file changing and the .db file changing during the 2.5 hours to create. On the production .db file, nothing is happening. I have all associated processes killed that ineract with the db file, so I know it is not locked. -- View this message in context: http://www.nabble.com/Index-creation-tf3451503.html#a9627719 Sent from the SQLite mailing list archive at Nabble.com.
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
