Re: Cross database query

You can enable table spaces with the latest version. This should reduce the growth of the .data file.

Fred

On Tue, Jun 23, 2020, at 17:33, Sébastien Pérès-Labourdette wrote:
> 
> My fault. Sorry for that dummy one.
>  Defrag + Backup is much much more optimal !
> 
>  --
>  Sébastien
> 
> 
> *De : *Fred Toussi Via Hsqldb-user <[email protected]>
> *Envoyé : * Mardi 23 Juin 2020 14:22:16
> *À : *Hsqldb User List <[email protected]>
> *Cc : *Fred Toussi <[email protected]>
> *Objet : *Re: [Hsqldb-user] Cross database query
>> I don't know how this happens. The backup AS FILES simply copies the files.
>> 
>> You can get paid support for this sort of issues.
>> 
>> Fred
>> 
>> 
>> On Tue, Jun 23, 2020, at 11:34, Sébastien Pérès-Labourdette wrote:
>>> Thanks Fred for your wise answer.
>>> I'll dig into that.
>>> 
>>> I have another issue while using 
>>> 
>>> BACKUP DATABASE TO '" + backupPath + "' NOT BLOCKING AS FILES
>>> 
>>> on some databases.
>>> 
>>> _Example :_
>>> I have following files on my server (cumulated size is approximately 150M)
>>> -rw-r--r-- 1 root root 12M Jun 23 12:11 cache-cgp.backup
>>>  -rw-r--r-- 1 root root 64M Jun 23 12:15 cache-cgp.data
>>>  -rw-r--r-- 1 root root 16 Jun 23 12:30 cache-cgp.lck
>>>  -rw-r--r-- 1 root root 76M Jun 23 12:30 cache-cgp.log
>>>  -rw-r--r-- 1 root root 101 Jun 23 11:54 cache-cgp.properties
>>>  -rw-r--r-- 1 root root 45K Jun 23 11:54 cache-cgp.script
>>> 
>>> 
>>> Backup database on this database generates a 17G file
>>> -rw-r--r-- 1 root root 17G Jun 23 11:45 cache-cgp.data
>>>  -rw-r--r-- 1 root root 101 Jun 23 11:40 cache-cgp.properties
>>>  -rw-r--r-- 1 root root 45K Jun 23 11:40 cache-cgp.script
>>> How come ?
>>> 
>>> 
>>> *De : *Fred Toussi Via Hsqldb-user <[email protected]>
>>> *Envoyé : * Mardi 9 Juin 2020 11:09:29
>>> *À : *Hsqldb User List <[email protected]>
>>> *Cc : *Fred Toussi <[email protected]>
>>> *Objet : *Re: [Hsqldb-user] Cross database query
>>>> HSQLDB supports queries combining tables in multiple schemas in the same database. It does not support queries on multiple databases.
>>>> 
>>>> If your databases are not too large, you should be able to automate a data export / import setup to create and update one combined database for querying.
>>>> 
>>>> Alternatively, this JDBC tool might be a solution www.unityjdbc.com/
>>>> 
>>>> Fred Toussi
>>>> 
>>>> On Mon, Jun 8, 2020, at 22:58, Sébastien Pérès-Labourdette wrote:
>>>>> Hi there.
>>>>> 
>>>>> I have an 2.5 hsqldb server hosting 6 database instances sharing quite
>>>>> the same db schema.
>>>>> How to compose queries mixing joins from / to structures hosted on
>>>>> different database from / to structures hosted on the currently
>>>>> connected one, on the same server ?
>>>>> 
>>>>> Cheers
>>>>> --
>>>>> Sébastien
>>>>> 
>>>>> 
>>>>> 
>>>>> 
>>>>> 
>>>>> 
>>>>> _______________________________________________
>>>>> Hsqldb-user mailing list
>>>>> [email protected]
>>>>> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>>>>> 
>>>>> 
>>>>> *Attachments:*
>>>>>  * signature.asc
>>>> 
>>>> 
>>>> 
>>>> _______________________________________________
Hsqldb-user mailing list
>>>> [email protected]
>>>> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

>>>> 
>>> 
>>> _______________________________________________
>>> Hsqldb-user mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>>> 
>>> 
>>> *Attachments:*
>>>  * signature.asc
>> 
>> 
>> 
>> _______________________________________________
Hsqldb-user mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>> 
> 
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> 
> 
> *Attachments:*
>  * signature.asc

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user