* Domingo Alvarez Duarte: > After 12 hours inserting of: > > 934,135,285 records on bolsas_familia > > 22,711,259 records in favorecidos > > 5,570 records in municipios > > ...
Insertion will be faster if you create the index after populating the tables. > time sqlite3 bolsa_familia3.db "vacuum;" > > real 147m6.252s > user 10m53.790s > sys 3m43.663s You really need to increase the cache size if at all possible. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users