Re: [Virtuoso-users] Memory pool, slow queries, getting values for every predicate

2011-02-08 Thread Hugh Williams
Hi Luka, A fairer comparison would be between the the query run from PHP via ODBC and the same query run using the Virtuoso isql command line tool which both use the same SQL interface to Virtuoso, rather then the sparql endpoint over HTTP. Can you also enable ODBC tracing and provide an ODBC

Re: [Virtuoso-users] Memory pool, slow queries, getting values for every predicate

2011-02-08 Thread Luka
Hi Hugh, the thing is I solved this problem by adding LIMIT in my query and putting it to a a reasonable value (in my case 100 is enough) and now the query results are being returned reasonably fast. Maybe this can be a clue to you... Thank you anyway for the sugggestion. I'll try enabling

Re: [Virtuoso-users] Memory pool, slow queries, getting values for every predicate

2011-02-08 Thread Kingsley Idehen
On 2/8/11 6:18 PM, Luka wrote: Hi Hugh, the thing is I solved this problem by adding LIMIT in my query and putting it to a a reasonable value (in my case 100 is enough) and now the query results are being returned reasonably fast. Maybe this can be a clue to you... Thank you anyway for the

[Virtuoso-users] Memory pool, slow queries, getting values for every predicate

2011-02-06 Thread Luka
Hi everyone, I am using php on Apache and querying Virtuoso RDF graph using ODBC. Everyithing on my localhost... I have two questions today :p A) Yesterday I got an Virtuoso (opensource) error saying: / odbc_exec() [function.odbc-exec]: SQL error: [OpenLink][Virtuoso ODBC Driver][Virtuoso