Hi Joe,

Sorry for the delay, I had to solve an server problem first. This is the sql 
query I've been testing with

SELECT 
        GROUP_CONCAT(Parent.fkintFolderID,'\') FilePath 
FROM tblFolderNestedSets Node
,tblFolderNestedSets Parent
WHERE 
        Node.intLeft 
BETWEEN 
        Parent.intLeft AND Parent.intRight 
AND 
        Parent.fkintSessionID = Node.fkintSessionID 
AND 
        Node.fkintSessionID =  1817 
AND 
        Node.fkintFolderID  = 1937926;

And this is the table:

CREATE TABLE tblFolderNestedSets (
  pkintFolderNestedSetID  integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  fkintSessionID          integer NOT NULL,
  fkintFolderID           integer NOT NULL,
  intLeft                 integer,
  intRight                integer
);

It runs perfectly with the C++ test sample and very slow on ADO.Net SQLite 
library. I don't know why.

Thank you for your time and effort.

With regards,

Peter


>-----Original Message-----
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
>On Behalf Of Joe Mistachkin
>Sent: maandag 13 oktober 2014 20:31
>To: 'General Discussion of SQLite Database'
>Subject: Re: [sqlite] group_concat query performance
>
>
>Kraijenbrink - FixHet - Systeembeheer wrote:
>>
>> 1. "SQLitePerfTest - C++ " runs very fast. 50.000 queries in 8 or 9
>seconds;
>>
>> 2. "SQLitePerfTest - VB.net  runs very fast. 50.000 queries in 7 or 8
>seconds.
>>    (Without the GROUP_CONCAT function that is;)
>> 
>> 3. "SQLitePerfTest - VB.net  which runs slow, 50.000 queries in 5 or 6
>minutes;  
>> 
>
>Are you able to share the query and the schema of the database involved?
>
>If you have sample code, that might reveal important details as well.
>
>--
>Joe Mistachkin
>
>_______________________________________________
>sqlite-users mailing list
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to