Thank you very much!
/** Disk-Space Utilization Report For junk.db3
Page size in bytes 1024
Pages in the whole file (measured) 27606264
Pages in the whole file (calculated).. 24264026
Pages that store data..
sqlite3_analyzer.exe ended with 16 INSERT statements showing in my Windows 7
CMD console screen:
They look similar to this one:
INSERT INTO space_used
VALUES(‘Deductions’,’Deductions’,0,0,0,0,0,0,16,0,0,1024);
I remember helping someone try to get a UNION statement correct a few months
ago.
Th
Last statement 2 statements were:
insert into space_used
values(‘MyTable,”MyTable,0,728251738,704277138,588,0,0,26,285986,23974601,0,34710955,683321040,0,12,24842841088);
COMMIT;
-
May
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/Database-corrupted-28-billion-bytes-
>What is the output from the following:
> PRAGMA page_size;
> PRAGMA journal_mode;
> PRAGMA freelist_count;
> PRAGMA page_count;
1024
delete
0
27606264
The sqlite3_analyzer,exe is running.
-
May
--
View this message in context:
http://sqlite.1065
Found table that was huge, it was named MyTable.
It was created with:
Create Table MyTable(comment);
select max(rowid),* from MyTable;
80002 "This","is"," 4"
Drop table Mytable;
Vacuum.
It went down to a little over 3,000,000 bytes.
I'm going to include a filesize routine withi
5 matches
Mail list logo