Re: [Virtuoso-users] upgrade triplestore to column store

2013-07-09 Thread Alexey Zakhlestin
Thanks, Hugh! It worked like charm. Here's a pull-request, which disables transaction log for period of conversion: https://github.com/openlink/virtuoso-opensource/pull/65 On 08.07.2013, at 20:18, Hugh Williams wrote: > Hi Alexey, > > Yes, you can use that script which rename the original

Re: [Virtuoso-users] upgrade triplestore to column store

2013-07-08 Thread Hugh Williams
Hi Alexey, Yes, you can use that script which rename the original row wise RDF_QUAD tables create an empty column wise RDF_QUAD table and insert the data from the rename table into it. You verify if the index type of the table is column, index, or bitmap using a query of the form: SQL> SELECT

[Virtuoso-users] upgrade triplestore to column store

2013-07-08 Thread Alexey Zakhlestin
As far as I understand, Virtuoso/7 doesn't do any automatic conversions of existing databases to column-based. So, what is the proper procedure for upgrading triplestore to column-based indices? Marketing materials tell that it is recommended for large datasets :) Should I just execute this scri