[Solved] Size of backend db

Creating tables and queries

[Solved] Size of backend db

Postby gkick » Thu Sep 26, 2019 9:42 pm

Hi,

Prior to split some of my tables had a memo field which I understand from the doco are clob datatype in the backend?
At present I have a total of 5 clobs and one blob for images, actual data at present, the clobs are just a one liner, the blob has 2 small images. Total records all tables no more then 50 excluding the reference(lookup tables) which have a pk and a single varchar field.
Checking the size the overall db folder containing everything shows up as 42mb s. Is that normal or should I convert the clobs to some other datatype?
Thanks.
Attachments
Space.JPG
Last edited by gkick on Fri Sep 27, 2019 4:30 am, edited 1 time in total.
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 186
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Size of backend db

Postby Villeroy » Thu Sep 26, 2019 9:53 pm

menu:Tools>SQL...
SHUTDOWN COMPACT
Restart LibreOffice
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27707
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Size of backend db

Postby gkick » Thu Sep 26, 2019 11:10 pm

Thank you Villeroy, forgot to mention this is the compacted size.
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 186
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Size of backend db

Postby UnklDonald418 » Fri Sep 27, 2019 12:50 am

Looking in the HSQL User Guide, the section
Short Guide to Data Types says "The CLOB types is for very large strings. Do not use this type for short strings as there are performance implications"
A few pages later in section
Lob Data is a discussion of the *.lobs file.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.7 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1286
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Size of backend db

Postby gkick » Fri Sep 27, 2019 4:29 am

Thanks, going to change the datatype as one of my reports has a problem reading a clob as well even though the query displays the contents ok.
Attachments
clob.JPG
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 186
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 1 guest