Re: [sqlite] huge performance decrease after deleting/creating a table !

2011-01-12 Thread Philip Graham Willoughby
On 12 Jan 2011, at 15:12, Vander Clock Stephane wrote: > before it's return in 100 ms now 30 secondes :( > > What i do wrong and how to correct it ? Issue the SQL command: ANALYZE This will help the query planner understand which indexes are best to use; I have seen it dramatically improve

[sqlite] huge performance decrease after deleting/creating a table !

2011-01-12 Thread Vander Clock Stephane
hello, i want to update a column name in a table, but the only way for that is to redo the table the table have around 15 000 000 records so i do like this : ALTER TABLE PICTURE_HASH_ID RENAME TO PICTURE_HASH_ID_OLD; DROP INDEX PICTURE_HASH_ID_PIC_IDX; CREATE TABLE PICTURE_HASH_ID( HASH_ID