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