Re: [sqlite] Sizeof tables

2010-08-20 Thread Lukas Haase
Am 18.08.2010 16:09, schrieb Max Vlasov: > On Tue, Aug 17, 2010 at 4:28 PM, Lukas Haase wrote: > >> Hi, >> >> My sqlite database is about 65 MB. The data is split into serval tables. >> >> Is there a way to enumerate the space requirements for each table so >> that I can see which tables are the m

Re: [sqlite] Sizeof tables

2010-08-19 Thread Richard Hipp
Download the sqlite3_analyzer.exe utility from the website and run it on your database file. On Tue, Aug 17, 2010 at 8:28 AM, Lukas Haase wrote: > Hi, > > My sqlite database is about 65 MB. The data is split into serval tables. > > Is there a way to enumerate the space requirements for each tabl

Re: [sqlite] Sizeof tables

2010-08-19 Thread Simon Slavin
On 17 Aug 2010, at 1:28pm, Lukas Haase wrote: > My sqlite database is about 65 MB. The data is split into serval tables. > > Is there a way to enumerate the space requirements for each table so > that I can see which tables are the memory consumers? Do you see the space taken by indexes as bei

Re: [sqlite] Sizeof tables

2010-08-18 Thread Max Vlasov
On Tue, Aug 17, 2010 at 4:28 PM, Lukas Haase wrote: > Hi, > > My sqlite database is about 65 MB. The data is split into serval tables. > > Is there a way to enumerate the space requirements for each table so > that I can see which tables are the memory consumers? > > Look at this discussion: http

[sqlite] Sizeof tables

2010-08-18 Thread Lukas Haase
Hi, My sqlite database is about 65 MB. The data is split into serval tables. Is there a way to enumerate the space requirements for each table so that I can see which tables are the memory consumers? Regards, Luke ___ sqlite-users mailing list sqli