SELECT count(*) FROM mra_hashtags;
 read_nb_lines : (27,)
SELECT count(*) FROM sqlite_sequence;
 read_nb_lines : (3,)
SELECT count(*) FROM mra_cache_counter;
 read_nb_lines : (750,)
SELECT count(*) FROM mra_photos;
 read_nb_lines : (154702,)
SELECT count(*) FROM mra_photo_hashtag_ids;
 read_nb_lines : (0,)
SELECT count(*) FROM mra_portfolios;
 read_nb_lines : (0,)
SELECT count(*) FROM mra_portfolio_photos;
 read_nb_lines : (0,)
SELECT count(*) FROM mra_gps;
 read_nb_lines : (0,)
 size : 34787328
 data_start : {'mra_hashtags_nb_lines': (27,), 'sqlite_sequence_nb_lines': (3,), 'mra_cache_counter_nb_lines': (750,), 'mra_photos_nb_lines': (154702,), 'mra_photo_hashtag_ids_nb_lines': (0,), 'mra_portfolios_nb_lines': (0,), 'mra_portfolio_photos_nb_lines': (0,), 'mra_gps_nb_lines': (0,), 'size_file': 34787328}

 Starting time : 1767275222.3886592


NoneElapsed time : 4.0531158447265625e-06


clean mra_photosElapsed time : 24.182486057281494


VACUUMElapsed time : 180.81189465522766

SELECT count(*) FROM mra_photos;
 read_nb_lines : (141705,)
 size : 31641600
 data_end : {'mra_photos_nb_lines': (141705,), 'size_file': 31641600}
{'start': {'mra_hashtags_nb_lines': (27,), 'sqlite_sequence_nb_lines': (3,), 'mra_cache_counter_nb_lines': (750,), 'mra_photos_nb_lines': (154702,), 'mra_photo_hashtag_ids_nb_lines': (0,), 'mra_portfolios_nb_lines': (0,), 'mra_portfolio_photos_nb_lines': (0,), 'mra_gps_nb_lines': (0,), 'size_file': 34787328}, 'end': {'mra_photos_nb_lines': (141705,), 'size_file': 31641600}}
SELECT count(*) FROM mra_hashtags;
 read_nb_lines : (27,)
SELECT count(*) FROM sqlite_sequence;
 read_nb_lines : (3,)
SELECT count(*) FROM mra_cache_counter;
 read_nb_lines : (750,)
SELECT count(*) FROM mra_photos;
 read_nb_lines : (142343,)
SELECT count(*) FROM mra_photo_hashtag_ids;
 read_nb_lines : (0,)
SELECT count(*) FROM mra_portfolios;
 read_nb_lines : (0,)
SELECT count(*) FROM mra_portfolio_photos;
 read_nb_lines : (0,)
SELECT count(*) FROM mra_gps;
 read_nb_lines : (0,)
 size : 31838208
 data_start : {'mra_hashtags_nb_lines': (27,), 'sqlite_sequence_nb_lines': (3,), 'mra_cache_counter_nb_lines': (750,), 'mra_photos_nb_lines': (142343,), 'mra_photo_hashtag_ids_nb_lines': (0,), 'mra_portfolios_nb_lines': (0,), 'mra_portfolio_photos_nb_lines': (0,), 'mra_gps_nb_lines': (0,), 'size_file': 31838208}

 Starting time : 1767281822.7419348


NoneElapsed time : 5.0067901611328125e-06

Error :database is locked

clean mra_photosElapsed time : 5.010415315628052

Error :database is locked
Error :cannot VACUUM from within a transaction

VACUUMElapsed time : 0.0003609657287597656

SELECT count(*) FROM mra_photos;
 read_nb_lines : (142343,)
 size : 31838208
 data_end : {'mra_photos_nb_lines': (142343,), 'size_file': 31838208}
{'start': {'mra_hashtags_nb_lines': (27,), 'sqlite_sequence_nb_lines': (3,), 'mra_cache_counter_nb_lines': (750,), 'mra_photos_nb_lines': (142343,), 'mra_photo_hashtag_ids_nb_lines': (0,), 'mra_portfolios_nb_lines': (0,), 'mra_portfolio_photos_nb_lines': (0,), 'mra_gps_nb_lines': (0,), 'size_file': 31838208}, 'end': {'mra_photos_nb_lines': (142343,), 'size_file': 31838208}}
