Re: [sqlite] How do I optimize a query in this situation?

y string can be up to 5KB, or even 20KB if the user continues to use the program. Is that too long for the engine to perform good? Thanks again! Best regards, He Shiming ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How do I optimize a query in this situation?

things down, and I wanted some quick response before seeing the actual content. It looks like other options will also slow down the second query. So I would like to know if it's okay to have queries running this way? Is it typically done this way or can I improve it? Many thanks in advance, He

Re: [sqlite] Help on sql syntax, left join and group_concat

oup_concat. I could use additional queries to fetch the data from T2. But I figured as long as it's done in a single query instead of multiple, the performance shall be better. Please correct me if I'm wrong here, because I'm not so sure if I'm heading i

[sqlite] Help on sql syntax, left join and group_concat

; And the result is: John, 9,5,8, B,U,T What I want is to make the join part sorted by T2.COUNT, so that the result goes: John, 5,8,9, U,T,B I can't think of a way to make it happen. I tried putting in an additional ORDER BY T2.COUNT but it has no effect. Any hints? Thanks in advance, He Shiming

Re: [sqlite] group_concat for binary?

look fine. I'll post again if I ran into troubles. Best regards, He Shiming -- From: "John Stanton" <[EMAIL PROTECTED]> Sent: Monday, March 10, 2008 12:24 PM To: "General Discussion of SQLite Database" <sqlite-users@sql

[sqlite] group_concat for binary?

that contains the encoded text representation of the BLOB? Thanks in advance, He Shiming ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question - Multiple Users, Multiple files

properly. My 2 cents. Best regards, He Shiming - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite Order BY

in where clause and order by clause. Best regards, He Shiming - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite Order BY

); Icol 14 varchar(1); Icol 15 varchar(1); Icol 16 varchar(1); There is one index on itm.Icol1. You can try creating two additional indexes, one on hvh5m.Column4 and the other on hvh5m.Column8. They should speed things up. Best regards, He Shiming

Re: [sqlite] results of SELECT contains carriage returns

sed to parse them, you can get them directly through these APIs. You might want to learn more about a database management system, after all, sqlite is one. Best regards, He Shiming - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Regarding sqlite3_exec

mes to a database query resultset. A better way would be to use an array to store the result set they way you could understand, and process them later. Then you'll have for(i=0;i<array.size()<10?array.size():10;i++

Re: Re[2]: [sqlite] Regarding aborting a query

Actually it implements such syntax. See LIMIT and OFFSET at http://www.sqlite.org/lang_select.html Filip Right, I missed that. Sorry for the confusion. Best regards, He Shiming - To unsubscribe, send email

Re: [sqlite] Regarding aborting a query

, you break the while loop. 4. Call sqlite3_reset or sqlite3_finalize, and yes you can reset or finalize a query when it's not done. Best regards, He Shiming - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Regarding Performance and removing create view

necessary to do some benchmarks and use queries such as EXPLAIN QUERY PLAN SELECT * ... to find out whether these indexes are improving the performance. Best regards, He Shiming - To unsubscribe, send email to [EMAIL

Re: [sqlite] Multiple Updates

transaction is used for such an update or insert iteration. If you don't know it yet, another idea is to use PRAGMA synchronous = OFF; . This way, sqlite will rely on operating system disk cache, which is an even greater improvement in performance. Best

Re: [sqlite] Locking problems

qlite3_reset to reset the statement. I suggest that you check your code very carefully to see if any statements are not finalized or resetted. Best regards, He Shiming - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Wish to store a C structure in sqlite column

et started, a pointer, and the size. Best regards, He Shiming - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Disabling locking?

not your choice. If you need to execute parallel queries, you have to open another connection and handle busy status. Locking is not a feature for you to disable. It's a fact that you can't read or write before another writing process is finished. Best regards, He Shiming

Re: [sqlite] Quotation handling bug?

and use double-quotes or brackets around identifiers so your code is more readable and explicit. Robert That's very helpful. Thanks. Best regards, He Shiming - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Quotation handling bug?

g I did wrong? Best regards, He Shiming - To unsubscribe, send email to [EMAIL PROTECTED] -