On 5/9/14 9:34 AM, Bart Vandewoestyne wrote:
On 2014-05-09 15:20, Bart Vandewoestyne wrote:>On 2014-05-09 15:05, Kingsley Idehen wrote:>>[...] >>Are you using /sparql or isql command-line to perform these queries?> >I am using OpenLink Interactive SQL (Virtuoso), version 0.9849b. in both >interactive and batch mode. >>>How many triples to you have in the Virtuoso Quad Store?> >SQL> sparql SELECT COUNT(*) { ?s ?p ?o }; >callret-0 >INTEGER >_______________________________________________________________________________ > > >2164637247 > >1 Rows. -- 1923 msec. > > >Feel free to let me know what else I can test in order to investigate >this any further.Maybe it's also worthwhile to mention that I see the following errors in my log:15:12:13 ERROR: Error compiling stored procedure: 42S22: SQ062: No column N.RES_SIZE. -- #line 4150 "[executable]/dav.sql" create trigger SYS_DAV_RE 15:12:13 ERROR: Error compiling stored procedure: 42S22: SQ062: No column O.RES_SIZE. -- #line 4242 "[executable]/dav.sql" create trigger SYS_DAV_RE 15:12:13 ERROR: Error compiling stored procedure: 42S22: SQ063: No column RES_SIZE. -- #line 4699 "[executable]/dav.sql" create trigger SYS_DAV_RE I have no idea if this has anything to do with it or not. Kind regards, Bart
It shouldn't.You count(*) solution should be the same each time you run it, modulo and additions or removal of triples from the quad store.
Do you have output from say 3 runs of this same query? -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Company Web: http://www.openlinksw.com Personal Weblog: http://www.openlinksw.com/blog/~kidehen Twitter Profile: https://twitter.com/kidehen Google+ Profile: https://plus.google.com/+KingsleyIdehen/about LinkedIn Profile: http://www.linkedin.com/in/kidehen
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ Is your legacy SCM system holding you back? Join Perforce May 7 to find out: • 3 signs your SCM is hindering your productivity • Requirements for releasing software faster • Expert tips and advice for migrating your SCM now http://p.sf.net/sfu/perforce
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users