I was thinking this too, but I take this for last chance: my hope is I can delete 5 millions of records in few seconds, science fiction? :)
Il 08/10/2010 9.00, Aldes Rossi ha scritto: > Il 10/08/2010 08:30 AM, Michele Pradella ha scritto: >> I don't know if could be faster to do more Delete of less records, or >> perhaps making a VIEW and than deleting all the records matching the >> VIEW. I'm thinking about this to find the fastest solution, because the >> problem is that when sqlite is deleting the records obviously I can not >> access the DB for insert new records and all the operations have to wait >> for delete complete...and 4-5minutes is too much time to wait. > Maybe splitting this operation in many Delete of less record lengthens the > total time, but results in shortest service interruptions, and may in > fact be > more acceptable. > > Aldes Rossi > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- Selea s.r.l. Michele Pradella R&D SELEA s.r.l. Via Aldo Moro 69 Italy - 46019 Cicognara (MN) Tel +39 0375 889091 Fax +39 0375 889080 *michele.prade...@selea.com* <mailto:michele.prade...@selea.com> *http://www.selea.com* _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users