Re: [sqlite] Totalview Debugger & MemoryScape showing leak in my SQLite code?

Hi Pavel, Many thanks for your comments.I will try put together some better code and if I have any issues I will ask again... Thanks again Lynton -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent:

Re: [sqlite] Sqlite+ICU library and usage of LIKE

"It's rather pointless to use a LIKE operator with no wildcards." Except that it performs a case-insensitive comparison, so a quick-and-dirty way to accomplish that. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor

Re: [sqlite] Sqlite+ICU library and usage of LIKE

Some elementary issue in my code, works fine now. Tks -Sreekumar 2011/9/6 Sreekumar TP > I get the following error when I use % or _ > > error @ 101, 1,1,unrecognized token: "'м" > > > > On Tue, Sep 6, 2011 at 9:21 PM, Igor Tandetnik wrote: > >> On

Re: [sqlite] Sqlite+ICU library and usage of LIKE

I get the following error when I use % or _ error @ 101, 1,1,unrecognized token: "'м" On Tue, Sep 6, 2011 at 9:21 PM, Igor Tandetnik wrote: > On 9/6/2011 11:41 AM, Sreekumar TP wrote: > >> If I modify the statement to return all strings which match 'м' , No >> strings >>

Re: [sqlite] Sqlite+ICU library and usage of LIKE

On 9/6/2011 11:41 AM, Sreekumar TP wrote: If I modify the statement to return all strings which match 'м' , No strings are fetched. zSQL = sqlite3_snprintf(1024,temp2,"SELECT * FROM l1 WHERE data LIKE 'м' ;"); You probably want LIKE 'м%'. It's rather pointless to use a LIKE operator with

[sqlite] Sqlite+ICU library and usage of LIKE

Hi, I am using ICU library to collate and pattern match strings in Russian language. I use C api to intialise the icu library . sqlite3IcuInit(db); zSQL = sqlite3_snprintf(1024,temp1,"SELECT icu_load_collation('ru_RU', 'RUSSIAN');"); sqlite3_prepare_v2(db,(const char *)zSQL,-1,, NULL); further

Re: [sqlite] Totalview Debugger & MemoryScape showing leak in my SQLite code?

> Well, in the first code example, yes you need to free your peekText pointer. > Since you passed SQLITE_STATIC for the destructor parameter to > sqlite3_bind_text, you should free it before you exit the function and not > before.  If you use SQLITE_TRANSIENT, you can free it immediately after the

Re: [sqlite] Totalview Debugger & MemoryScape showing leak in my SQLite code?

Well, in the first code example, yes you need to free your peekText pointer. Since you passed SQLITE_STATIC for the destructor parameter to sqlite3_bind_text, you should free it before you exit the function and not before. If you use SQLITE_TRANSIENT, you can free it immediately after the bind

Re: [sqlite] conversion of MySQL database table to Sqlite database table (Kees Nuyt)

On Tue, 6 Sep 2011 03:17:23 -0400, Frank Chang wrote: > Kees Nuyt, I studied your producer-consumer > multithreading further with respect to our proposed > application. If the speed of MySQL reads is much faster > than the the Speed of SQLite writes, then in the >

Re: [sqlite] Help with SQLite error message

https://discussions.apple.com/message/15712311#15712311 -- Marco Bambini http://www.sqlabs.com On Sep 5, 2011, at 10:46 PM, Lani Gonzales wrote: > Dear Technical Support: > > Please help me remove this error message: > > The procedure entry point sqlite3_wal_checkpoint could not be

[sqlite] Totalview Debugger & MemoryScape showing leak in my SQLite code?

Hi there, I am a huge fan of SQLIte and have recently done some code that I am debugging with TotalView and MemoryScape (http://www.roguewave.com) - VERY VERY nice debugger, I have used GDB as well alot but Totalview is simply awesome NOTE: C coding is NOT my day job ;-) I am using

[sqlite] Totalview Debugger & MemoryScape showing leak in my SQLite code?

Hi there, I am a huge fan of SQLIte and have recently done some code that I am debugging with TotalView and MemoryScape (http://www.roguewave.com) - VERY VERY nice debugger, I have used GDB as well alot but Totalview is simply awesome NOTE: C coding is NOT my day job ;-) I am using

[sqlite] Help with SQLite error message

Dear Technical Support: Please help me remove this error message: The procedure entry point sqlite3_wal_checkpoint could not be located in the dynamic link library SQlite3.dll Please kindly send instructions on how to resolve this problem. Thank you, Lani Gonzales

[sqlite] Totalview Debugger & MemoryScape showing leak in my SQLite code?

Hi there, I am a huge fan of SQLIte and have recently done some code that I am debugging with TotalView and MemoryScape (http://www.roguewave.com) - VERY VERY nice debugger, I have used GDB as well alot but Totalview is simply awesome NOTE: C coding is NOT my day job ;-) I am using

Re: [sqlite] MemoryScape saying I have LEAKS in my SQLite code?

Hi there, Thanks for your comments, and I am passing NULL now to the busy handler..;-) I also say on the SQLite site that the pragma " default_cache_size " should not be used anymore (http://www.sqlite.org/pragma.html#pragma_default_cache_size ) ("Do not use this pragma! This pragma is

Re: [sqlite] MemoryScape saying I have LEAKS in my SQLite code?

On Tue, Sep 6, 2011 at 2:28 PM, Grice, Lynton (L) wrote: > May I ask what you suggest with the way I am using the > sqlite3_busy_handler? What is the "normal approach"? I have tried to look at > examples etc > Hi! i don't use the busy handler, so i can't say, but i do

Re: [sqlite] MemoryScape saying I have LEAKS in my SQLite code?

Hi Stephan, Many thanks for your response, much appreciated... May I ask what you suggest with the way I am using the sqlite3_busy_handler? What is the "normal approach"? I have tried to look at examples etc p = sqlite3_malloc(256); sqlite3_busy_handler(handle, , p); sqlite3_free(p); Also,

Re: [sqlite] MemoryScape saying I have LEAKS in my SQLite code?

While i can't answer the question about the leaks, i can say... On Tue, Sep 6, 2011 at 10:49 AM, Grice, Lynton (L) wrote: > int queue_peekByTID(const char *tid, message *msg){ > What is wrong with my code above? Must I FREE the char*? Why would > something say it was a

Re: [sqlite] Fine tuning of Sqlite

2011/9/6 Alexey Pechnikov : > 2011/9/6 jerome moliere : >> Could you give me more  details about corruption cases ? >> Is there a list of contexts where we can get corrupted tables ? > > http://www.sqlite.org/howtocorrupt.html Just one word :

Re: [sqlite] Fine tuning of Sqlite

2011/9/6 jerome moliere : > Could you give me more  details about corruption cases ? > Is there a list of contexts where we can get corrupted tables ? http://www.sqlite.org/howtocorrupt.html -- Best regards, Alexey Pechnikov. http://pechnikov.tel/

[sqlite] MemoryScape saying I have LEAKS in my SQLite code?

Hi there, I am a huge fan of SQLite and have recently done some code that I am debugging with TotalView and MemoryScape (http://www.roguewave.com) - VERY VERY nice debugger, I have used GDB as well alot but Totalview is simply awesome NOTE: C coding is NOT my day job ;-) So please bear

Re: [sqlite] Fine tuning of Sqlite

>> Indicies can be very >>> slow... may be the FTS4 table will be much faster for your queries. >> >> can you give more details about this concept ? what is the FTS4 table >> ? I am sorry don't know what is is !!! > > See > http://www.sqlite.org/fts3.html > The full-text index is very fast and

Re: [sqlite] Fine tuning of Sqlite

2011/9/6 jerome moliere : >  Did you set corresponding pragmas >> page_size, cache_size, journal_mode? > page_size yes > cache_size no because we are using a higher level cache (in Java) > journal_mode is in the list of the pragmas to be tested through the > benchmark

Re: [sqlite] Fine tuning of Sqlite

Hi once again I will answer to these questions (most of them) J.MOLIERE - Mentor/J auteur Eyrolles 2011/9/6 Alexey Pechnikov : > Jerome, can you show your database structure and queries? no definetely not I can't for legal reasons..sorry > Which FS is used? the only

Re: [sqlite] Fine tuning of Sqlite

Jerome, can you show your database structure and queries? Which FS is used? Did you set corresponding pragmas page_size, cache_size, journal_mode? Indicies can be very slow... may be the FTS4 table will be much faster for your queries. Do you use a prepared queries?.. Which type of storage are you

Re: [sqlite] Fine tuning of Sqlite

Hi Alexey, I thought I answered to those questions but once again : * my application runs on an embedded device (Honeywell 9900) , it's a very complex application (too much I think) and we are facing performance problems while inserting datas (about 500 objects to be inserted inducing about 2000

Re: [sqlite] conversion of MySQL database table to Sqlite database table (Kees Nuyt)

Kees Nuyt, I studied your producer-consumer multithreading further with respect to our proposed application. If the speed of MySQL reads is much faster than the the Speed of SQLite writes, then in the producer-consumer model , the consumer will spend a lot of time waiting for the SQLite write