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: [email protected] [mailto:[email protected]]
>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
>[email protected]
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
