Hugh:
That's correct. This is with 7.1 windows but this fact is documented
under 6.1.4 Limits in
http://docs.openlinksw.com/virtuoso/dbadm.html
(the section does not show as a HTML table but contains" Columns per row
200 ")
I think the column store SQL could provider a competitive option to
entry level big data solutions or for medium data use cases, but this
limit if correct would be a barrier to adoption.
best
*P
On 5/13/14, 3:14 AM, Hugh Williams wrote:
> Hi Pascal,
>
> By vertical storage I presume you mean column store ? Will have to
> check with the development if such a limit still exists on columns/per
> table. What is the version you are using (virtuoso-t -?) ?
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> Weblog -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
> On 12 May 2014, at 22:18, Pascal Heus <pascal.h...@mtna.us
> <mailto:pascal.h...@mtna.us>> wrote:
>
>> Hi:
>> We've been using Virtuoso for a while as an RDF store but are also
>> investigating options to use the SQL server as the vertical storage
>> introduced in 7.x makes it an attractive candidate for medium/big data
>> solutions. It however appears that there is a limit of 200 columns/table
>> which is a significant constraints (we have records with thousands of
>> variables). Can you confirm that this is the case. Is this something
>> that can be configured or a hard limit?
>> best
>> *P
>>
>> ------------------------------------------------------------------------------
>> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
>> Instantly run your Selenium tests across 300+ browser/OS combos.
>> Get unparalleled scalability from the best Selenium testing platform
>> available
>> Simple to use. Nothing to install. Get started now for free."
>> http://p.sf.net/sfu/SauceLabs
>> _______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
