Bart,
On 26 May 2014, at 13:03, Bart Vandewoestyne
wrote:
> On 2014-05-18 16:11, Hugh Williams wrote:
>> Hi Sumit
>>
>> Ah, didn't realise you started with a v6 row store database, thus how
>> did you upgrade to v7 ?
>>
>> As if you simply check pointed and restarted the v6 database with a v7
On 2014-05-18 16:11, Hugh Williams wrote:
> Hi Sumit
>
> Ah, didn't realise you started with a v6 row store database, thus how
> did you upgrade to v7 ?
>
> As if you simply check pointed and restarted the v6 database with a v7
> binary then it would be automatically upgraded but all the tables
> i
n order to maximize
> performance.
>
>
>
> Thanks
> sumit
>
> -Original Message-
> From: Kingsley Idehen [mailto:kide...@openlinksw.com]
> Sent: Thursday, May 22, 2014 7:24 AM
> To: virtuoso-users@lists.sourceforge.net
> Subject: Re: [Virtuoso-us
n order to maximize
> performance.
>
>
>
> Thanks
> sumit
>
> -Original Message-
> From: Kingsley Idehen [mailto:kide...@openlinksw.com]
> Sent: Thursday, May 22, 2014 7:24 AM
> To: virtuoso-users@lists.sourceforge.net
> Subject: Re: [Virtuoso-us
o maximize
performance.
Thanks
sumit
-Original Message-
From: Kingsley Idehen [mailto:kide...@openlinksw.com]
Sent: Thursday, May 22, 2014 7:24 AM
To: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Using column store structure for exiting data
On 5/22/14 9:50 AM
On 5/22/14 9:50 AM, Kingsley Idehen wrote:
Is it normal that re-loading the data takes significantly more time than
dumping it?
Regards,
Bart
Yes, for the following reasons:
1. Exporting is just about writing to files
2. Importing is about indexing and writing to internal identifiers
(named
On 5/22/14 8:33 AM, Bart Vandewoestyne wrote:
On 2014-05-18 16:11, Hugh Williams wrote:
>Hi Sumit
>
>Ah, didn't realise you started with a v6 row store database, thus how
>did you upgrade to v7 ?
>
>As if you simply check pointed and restarted the v6 database with a v7
>binary then it would be a
On 2014-05-22 14:33, Bart Vandewoestyne wrote:
>
> Hugh and list,
>
> I just wanted to report my findings with this first option:
>
> I have a virtuoso.db file of 142 GB and it took one night to dump it to
> .ttl and .graph files. The .ttl and .graph files together take 242 GB.
>
> Re-loading the
On 2014-05-18 16:11, Hugh Williams wrote:
> Hi Sumit
>
> Ah, didn't realise you started with a v6 row store database, thus how
> did you upgrade to v7 ?
>
> As if you simply check pointed and restarted the v6 database with a v7
> binary then it would be automatically upgraded but all the tables
> i
On 2014-05-21 00:03, Hugh Williams wrote:
> Hi Summit/Bart,
>
> The sys_keys table can then be queried to verify if the index type of the
> table is column, row (index, or bitmap) wise:
>
> SQL> SELECT TOP 10 KEY_TABLE, sys_sql_val_print (KEY_OPTIONS)
>FROM sys_keys
>WHERE KEY_TABLE = 'DB
sec.
>
>
> You also asked about how did i upgrade virtuoso : I recompile it from source
> and then used my older ini file as i have made some performance tuning it
> that.
>
> --sumit
>
>
>
> From: Hugh Williams [hwilli.
e virtuoso : I recompile it from source
and then used my older ini file as i have made some performance tuning it that.
--sumit
________
From: Hugh Williams [hwilli...@openlinksw.com]
Sent: Tuesday, May 20, 2014 3:03 PM
To: Purohit, Sumit
Cc: Bart Vandewoestyne; virt
egration, and Management Technology Providers
On 20 May 2014, at 22:35, "Purohit, Sumit" wrote:
> I +1 Bart's question as I also want to know which tables are using latest
> column store.
> Is there a way ?
>
>
> Thanks
> Sumit Purohit
>
>
users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Using column store structure for exiting data
On 2014-05-18 16:11, Hugh Williams wrote:
> Hi Sumit
>
> Ah, didn't realise you started with a v6 row store database, thus how
> did you upgrade to v7 ?
>
> As if you simply check pointed a
On 2014-05-18 16:11, Hugh Williams wrote:
> Hi Sumit
>
> Ah, didn't realise you started with a v6 row store database, thus how
> did you upgrade to v7 ?
>
> As if you simply check pointed and restarted the v6 database with a v7
> binary then it would be automatically upgraded but all the tables
> i
; To: Purohit, Sumit
> Cc: virtuoso-users@lists.sourceforge.net
> Subject: Re: [Virtuoso-users] Using column store structure for exiting data
>
> Hi Sumit,
>
> By default all SQL tables would be created as row wise, if the ColumnStore=1
> setting is in place then any new S
From: Hugh Williams [hwilli...@openlinksw.com]
Sent: Saturday, May 17, 2014 5:46 PM
To: Purohit, Sumit
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Using column store structure for exiting data
Hi Sumit,
By default all SQL tables would be created as
Hi Sumit,
By default all SQL tables would be created as row wise, if the ColumnStore=1
setting is in place then any new SQL tables created will be column wise, but
any existing table will not be auto converted or reindexed.
The one exception are the RDF_QUAD and associated tables and indexes us
Hi All,
I am using Virtuoso (Open Source) 7.1.0 and read about support of column-store
structure in virtuoso.
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html
Does setting ColumnStore=1 affect only tables created after the change OR DOES
IT RE-INDEX / RE-STRUCTURE exiting tables and ind
19 matches
Mail list logo
