Re: [sqlite] group_concat query performance

>Have you tested using a transaction over your combined queries? >Even for simple read operations this may give a huge performance difference. Yes, we did. Not only for performance reasons but for "automatic cleanup" in case of an error as well. -- Peter

Re: [sqlite] group_concat query performance

Thanks Bert, You are right. Now the C++ example runs equaly fast. Looks like I have to redesign the Db schema. With regards, Peter >Where do you perform the query in the C++ code? > >Your C++ program shows how you prepare the statement 5000 times, but not how >you execute it. > >The VB.Net

Re: [sqlite] group_concat query performance

Joe Mistachkin wrote: > >Thanks for the query. It's difficult to track down performance issues with >System.Data.SQLite without seeing the C# (or VB.NET) example code as there are >a variety of ways to query and process data using it. > >Is there any chance we could see the code that is using

Re: [sqlite] group_concat query performance

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. >

Re: [sqlite] group_concat query performance

Hi, I've created 3 test samples. A C++ (sqlite-amalgamation-3080600 .lib) and two VB.NET variants (sqlite-netFx40-binary-x64-2010-1.0.94.0). 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

Re: [sqlite] group_concat query performance

"SQLitePerfTest - VB.net which runs slow, 50.000 queries in 5 or 6 minutes; Thank you for your time and effort and hope to hear from you. With regards, Peter Kraijenbrink FixHet - Systeembeheer Geestdorp 22-II 3444 BD Woerden Tel: 0348-410220 Gsm: 06 - 27231926 Web: www.fixhet

Re: [sqlite] group_concat query performance

ering your question. > >On Thu, Sep 25, 2014 at 6:54 AM, Kraijenbrink - FixHet - Systeembeheer < >kraijenbr...@fixhet.nl> wrote: > >> Hi all, >> >> I've searched through this forum but couldn't find any related topic >> regarding my question. I'm having seriou

[sqlite] group_concat query performance

Hi all, I've searched through this forum but couldn't find any related topic regarding my question. I'm having serious performance problems (queries up to 20/sec) while running a SQLite query since i added a group_concat clause. The query looks like: SELECT